topic Re: Expression Issue.. in QlikView

Expression Issue..

vijayit43 — Tue, 18 Nov 2014 08:56:10 GMT

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..

Re: Expression Issue..

anbu1984 — Tue, 18 Nov 2014 09:00:56 GMT

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

Re: Expression Issue..

Gysbert_Wassenaar — Tue, 18 Nov 2014 09:02:42 GMT

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

Re: Expression Issue..

vijayit43 — Tue, 18 Nov 2014 11:07:02 GMT

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

Re: Re: Expression Issue..

anbu1984 — Tue, 18 Nov 2014 12:18:54 GMT

Check this

Re: Expression Issue..

vijayit43 — Tue, 18 Nov 2014 12:34:12 GMT

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

Re: Expression Issue..

vijayit43 — Tue, 18 Nov 2014 15:23:07 GMT

Hi Expert Please suggest...