topic Help needed for chart Expression in QlikView

Help needed for chart Expression

Wed, 21 Apr 2010 14:27:29 GMT

Hi Everyone

I am Deepak, I am new to qlikview

I have a question

In one bar chart i have expression

Sum( {$<[Country]={'India'}>} [Quantity] )

which means to include only Country India for Quantity as Expression in chart

But i have to do opposite of this Expression

I want to Know how to Exclude Country India only, from Quantity Expression

For this how to write Expression

Any Answer would be helpful for me

Thanking you all

Oleg_Troyansky — Wed, 21 Apr 2010 15:24:14 GMT

Use operator "-=" ("minus equal") instead of "=", like this:

Sum( {$<[Country] -= {'India'}>} [Quantity] )

Thu, 22 Apr 2010 07:29:24 GMT

Ok Thanks Oleg for your help