Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Annual Conference: Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

if condition how it works here?

if(  ValueList( 'Year 2011','Year 2010') = 'Year 2011',

  sum( {$<Year={2011}>} Sales),

  sum( {$<Year={2010}>} Sales)

)

how it works?

1 Solution

Accepted Solutions
Not applicable
Author

if(  ValueList( 'Year 2011','Year 2010') = 'Year 2011',   sum( {$<Year={2011}>} Sales),



if(  ValueList( 'Year 2011','Year 2010') = 'Year 2010',    sum( {$<Year={2010}>} Sales) )      this is the result right

View solution in original post

3 Replies
maxgro
MVP
MVP

bar chart

synthetic dimension is ValueList('Year 2011','Year 2010')

expression is your expression

1.png

Not applicable
Author

if(  ValueList( 'Year 2011','Year 2010') = 'Year 2011',   sum( {$<Year={2011}>} Sales),



if(  ValueList( 'Year 2011','Year 2010') = 'Year 2010',    sum( {$<Year={2010}>} Sales) )      this is the result right

ashfaq_haseeb
Champion III
Champion III

Yes this is right.

Regards

ASHFAQ