Expression Problem

[vijayit43]

In My qv dimension field state,brand and expression field

unique retailer=count distinct retailer from given period.

Unique Retailer Prev Period=   Unique Retailer for Prev Period where previous period is when from date(01/09) and      

                         to date(30/09) then diff day is 30,previous start date is (from date-30) is (02/08) and previous end date is      

                         (31/08) means previous period is 02/08-30/08.

Non Lifted Retailer=those Retailer which are common on unique retailer previous period and current period unique Retailer that Dimension  brand execlude

Example if brand A then unique retailer previous period brand A data common on current period All of Brand Excluding Brand A.

**Current period='01/09/2014' -'30/09/2014' and Prev Period='02/08/2014'-'31/08/2014'

how to achieve Non Lifted Retailer Please Suggest sample QV Attached .

[vijayit43]

Hi Expert Please suggest...

[jer_2011]

Hello,

I do not quite understand your needs, change the syntax, I hope you take it as an example to fix your application.

excuse me for my English is not very good

regards

[vijayit43]

we have using example.

current period=01/09/2014-30/09/2014

Previous Period=previous period is when from date(01/09/2014) and to date(30/09/2014) then diff day is 30,previous start date is (from date)-30 is (02/08) and previous end date is  (31/08) means previous period is 02/08/2014-30/08/2014.

dimension field state,brand

expression field 3 column

1-unique retailer=count distinct retailer from current period.

2 Unique Retailer Prev Period=   Unique Retailer for Prev Period

Non Lifted Retailer= In Dimension Brand A then we comparison  unique retailer previous period(Brand A Data) and current period unique Retailer(Brand B,C,D,None Data)  means we exclude brand A

more detail sample QV attached..

[vijayit43]

some one please suggest its very urgent.........

[jer_2011]

hi,

see attachment and take it as an example, it is not clear "no less Lifted" might make an example in Excel to help

regards

[vijayit43]

Problem Only in non lifted Retailer.other two column is correct.

Logic For Non Lifted Retailer If Dimension Brand A then We comparison on Unique Retailer Previous Period and Unique Retailer Current Period All Brand exclude Only dimension brand (Means Current Period Brand B,C,D,NONE Data)

We attached sample testBrand QV where we select one Brand  then its give right answer but when we not select any brand then return 0 in non lifted Retailer Please suggest..