Problem in calculation condition in Pivot..

[vijayit43]

In Table Structure one column is brand where brand is three type a,b and c .

when we create pivot table i want to take only two brand data a and b how to achieve it please suggest....

[ashfaq_haseeb]

Hi,

Similar question answered here

http://community.qlik.com/thread/141776

Regards

ASHFAQ

[#3]

try like this

sum({<brand={'a','b'}>}sales)

[Anonymous]

Hi Vijay,

   If you don't want the value of "a" then you can filter out at WHERE condition it self.

-Jay