Conditional functions
There are several conditional functions in QlikView that can be used in the frontend to give our charts a higher level of flexibility in terms of handling and presenting the data, both in expressions and dimensions. Let's go through some examples of these functions to enhance the analysis in our QlikView app.
The If function
Though sometimes
neglected because of its high resource usage when compared to other methods (such as Set Analysis, which is covered in the next chapter), the If
function has important uses when creating QlikView documents. Essentially, it is used when two or more different outputs should result from a single expression, depending on a condition that is evaluated to either be true
or false
.
In this section, we'll explain how it works and discuss a use case.
The syntax
As the first step, we should describe the syntax used by this function and the parameters it needs to work. If you've worked with Microsoft Excel previously, then it's very likely you...