Unselected Parameter Expression

cpkusuma — Sat, 01 Sep 2012 07:09:44 GMT

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.

Re: Unselected Parameter Expression

whiteline — Sat, 01 Sep 2012 08:07:15 GMT

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

Re: Unselected Parameter Expression

cpkusuma — Sat, 01 Sep 2012 09:06:47 GMT

Thank you for your reply, the expression solves my problem

topic Re: Unselected Parameter Expression in QlikView

Unselected Parameter Expression

Re: Unselected Parameter Expression

Re: Unselected Parameter Expression