Unselected Parameter Expression

[cpkusuma]

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.

[whiteline · Accepted solution]

=If(not isnull(GetFieldSelections(Month)), Sum(Cost), Sum({$-$<Month={"*"}>}Cost))

[cpkusuma]

Thank you for your reply, the expression solves my problem