topic Re: Re: Expression Problem in QlikView

Expression Problem

vijayit43 — Tue, 18 Nov 2014 10:21:30 GMT

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 .

Re: Expression Problem

vijayit43 — Tue, 18 Nov 2014 15:20:05 GMT

Hi Expert Please suggest...

Re: Expression Problem

jer_2011 — Wed, 19 Nov 2014 01:53:45 GMT

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

Re: Expression Problem

vijayit43 — Wed, 19 Nov 2014 02:26:47 GMT

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

Re: Expression Problem

vijayit43 — Wed, 19 Nov 2014 04:34:47 GMT

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

Re: Re: Expression Problem

jer_2011 — Wed, 19 Nov 2014 18:50:06 GMT

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

Re: Expression Problem

vijayit43 — Thu, 20 Nov 2014 02:02:22 GMT

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