topic Re: Problem In Expression Column.. in QlikView

Problem In Expression Column..

vijayit43 — Tue, 11 Nov 2014 09:33:41 GMT

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

Re: Problem In Expression Column..

Gysbert_Wassenaar — Tue, 11 Nov 2014 11:50:50 GMT

Try:

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

Re: Problem In Expression Column..

vijayit43 — Thu, 13 Nov 2014 06:17:54 GMT

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

Re: Problem In Expression Column..

Gysbert_Wassenaar — Thu, 13 Nov 2014 10:15:52 GMT

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.

Re: Problem In Expression Column..

vijayit43 — Fri, 14 Nov 2014 05:21:57 GMT

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