topic Re: if condition how it works here? in QlikView

if condition how it works here?

Sat, 25 Oct 2014 06:23:48 GMT

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

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

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

)

how it works?

maxgro — Sat, 25 Oct 2014 07:53:47 GMT

bar chart

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

expression is your expression

Sat, 25 Oct 2014 08:00:47 GMT

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 — Sun, 26 Oct 2014 13:47:33 GMT

Yes this is right.

Regards

ASHFAQ