Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm new to qlikview and I would like to ask about parameter and expression.
Period | Cost |
21,070.34 | |
1-Jan-12 | 38,008.46 |
1-Feb-12 | 24,446.99 |
1-Mar-12 | 16,234.31 |
1-Apr-12 | 24,148.52 |
1-May-12 | 13,229.94 |
1-Jun-12 | 17,093.20 |
The above table is the sample data I'm working on.
I set to Load Month(Period) as Month. I put it as Selectable Fields.
Month |
Jan |
Feb |
Mar |
Apr |
May |
Jun |
If I select Jan, then 38,008.48 will be selected on my table. My question is how can I set an expression if I did not select any month, then the 21,070.34 appear on my table, and if I select any month, then the number under cost will be selected.
Thank you in advance.
=If(not isnull(GetFieldSelections(Month)), Sum(Cost), Sum({$-$<Month={"*"}>}Cost))
=If(not isnull(GetFieldSelections(Month)), Sum(Cost), Sum({$-$<Month={"*"}>}Cost))
Thank you for your reply, the expression solves my problem