Sum Including all variables

Sat, 30 Apr 2011 09:06:30 GMT

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

Sum Including all variables

erichshiino — Sat, 30 Apr 2011 12:01:34 GMT

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,

topic Sum Including all variables in QlikView

Sum Including all variables

Sum Including all variables