Expression Issue..

[vijayit43]

In My QV State, Brand ,RetailerCode are Dimension and count retailercode in expression ...

Brand 3 Types A,B,C when we Select A then Count B and C Brand Retailer,when we Select B then Count A and C Brand Retailer,

when we Select C then Count A and B Brand Retailer how to achieve it Please Suggest..

[anbu1984]

=Count({Brand=E(Brand)}RetailerCode)

[Gysbert_Wassenaar]

count({<Brand=e(Brand)>} retailercode)

[vijayit43]

in above we put wrong question A,B,C is Dimension, when Dimension is A then Count B and C Brand Retailer,

when Dimension is B then Count A and C Brand Retailer,when Dimension is C then Count A and B Brand Retailer

[anbu1984]

Check this

[vijayit43]

Its Not Solve My Problem because my code is use

count({<VisitDate = {'>=$(=Date(vStartDate))<=$(=Date(vPrevEndDate))'}, RetailerCode=p({<Brand=e(Brand), VisitDate = {'>=$(=Date(vStartDateNew))<=$(=Date(vEndDateNew))'}>} RetailerCode)>} DISTINCT RetailerCode)

Its Work when we select Brand but when we no brand selected then give result 0 we want give actual result, how to solve its urgent.. detail link bellow

Expression Problem

[vijayit43]

Hi Expert Please suggest...