Exclude Dimension Brand data in Expression

vijayit43 — Thu, 20 Nov 2014 02:19:23 GMT

Hi Expert,

In My QV expression field 3 column 1.UniqueRetailer 2. Unique Retailer Prev Period 3.Non Lifted Retailer , 1st and 2nd column is correct only problem is 3rd Non Lifted Retailer.

QV Logic in Example(attached In Sample QV)

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(its correct).

2 Unique Retailer Prev Period= Unique Retailer for Prev Period (its correct).

Non Lifted Retailer= In Dimension Brand A then we comparison unique retailer previous period(Brand A Data) and current period All Brand exclude Only dimension brand (Means Current Period Brand B,C,D,NONE Data)

If we select any brand then return right answer but when we not select any brand return 0 how to achieve it.

For Sample qv Attached please suggest its urgent.

topic Exclude Dimension Brand data in Expression in QlikView

Exclude Dimension Brand data in Expression