Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
cpkusuma
Contributor
Contributor

Unselected Parameter Expression

Hi,

I'm new to qlikview and I would like to ask about parameter and expression.

PeriodCost
  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.

1 Solution

Accepted Solutions
whiteline
Master II
Master II

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

View solution in original post

2 Replies
whiteline
Master II
Master II

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

cpkusuma
Contributor
Contributor
Author

Thank you for your reply, the expression solves my problem