Element functions

We have two different types of element functions, which are as follows:

• P(): This uses all the possible values of a field.
• E(): This uses all the excluded values of a field.

The P() function uses all possible values in the field, and the E() function basically excludes, which means that it uses all the excluded fields based on the selection.

Element functions in action

We will now open the QlikView dashboard, go into the properties, and remove the entire expression we added in the previous section. We will replace that with the following expression:

{<Origin_WAC=p(Origin_WAC)>}

Now, whatever I select in the textual filters for Origin_WAC will appear in the dashboard. For example, let's select...