Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum Including all variables

I have 3 selector.

Year

Month

Client

In my QV the user can select values for all my graphics, but in one I need to calculate with all values of client selector and ignore the selection of if.

Thanks

1 Reply
erichshiino
Partner - Master
Partner - Master

If you want to ignore all selection to sum field AMOUNT for example, you can just write:
sum ({1} AMOUNT)

You can also ignore selection in one or more fields:

sum ({<Year = , Month = >}AMOUNT) , this will ignore selection on year and month, but users can still select the client.

Hope it helps,