Problem In Expression Column..

[vijayit43]

In MY qv dimension field state,brand and expression field

unique retailer=count distinct retailer from given period.

repeat retailer=common on given period retailer and previous period retailer where previous period is when from date(15/04) and       

                         to date(30/04) then diff day is 15,previous start date is (from date-15) is (01/04) and previous end date is       

                         (14/04) means previous period is 01/04-14/04.

New Retaile=not common on given period and previous period

Unique Retailer Prev Period=   Unique Retailer for Prev Period

Non Productive=how many unique retailer for current period which brand is 'NONE' common on previous Period Which Brand is 'XPW'

**Current period='15/04/2014' -'30/04/2014' and Prev Period='01/04/2014'-'14/04/2014'

**Unique Retailer,Repeat Retailer,New Retailer,Unique Retailer prev Period is show Correct figure But Non Product Show to wrong Figure how to solve it Please suggest..

** (when we select period from '15/04-30/04' and brand ='XPW' then Non Productive='216' right figure)

For Refrence sample QVW file Attached Please Suggest Its Urgent......

[Gysbert_Wassenaar · Accepted solution]

Try:

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

[vijayit43]

Its Not Work for me difference 2-3 retailer counting please suggest..

[Gysbert_Wassenaar]

I suggest you give more information than "Its Not Work for me". On my side it's "I can  haz worx ok, kthnxbbq!" The example I added shows a count of 216 like you asked for.

[vijayit43]

sorry,its works perfect problem in date variable now its working..