topic Regarding in set analysis coding in QlikView

Regarding in set analysis coding

qliksus — Wed, 23 Dec 2009 13:03:46 GMT

Hi,

I have a two Data field and one stock filed and one stockcode field. i.e DATE1,DATE2,STOCKQTY,STOCKCODE.

Now i am writing one expression which is giving me correct answer.

i.e COUNT(DISTINCT IF(DATE1=DATE2 AND STOCKQTY>0, STOCKCODE))

now i want to write same thing in SET ANALYSIS . BUT I AM UNABLE TO WRITE THE CORRECT SYNTAX.

CAN ANYONE HELP ME???????

BECAUSE I WANT SIMULTANEOUSLY FOR LAST CONSECUTIVE MONTHS WHAT IS STOCKCODE COUNT????

Regarding in set analysis coding

Miguel_Angel_Baeyens — Wed, 23 Dec 2009 14:48:27 GMT

Hello,

As far as I'm concerned, syntax would be something like (untested):

Count({< DATE1 = DATE2, STOCKQTY = {">0"} >} DISTINCT STOCKCODE)

Expression within brackets is the set analysis.

Regards.

Regarding in set analysis coding

qliksus — Wed, 23 Dec 2009 15:34:07 GMT

Hi,

Thanks for reply. But unfortunately it is not giving the correct answer. it is giving me count is 0.

Regarding in set analysis coding

Miguel_Angel_Baeyens — Wed, 23 Dec 2009 15:41:10 GMT

Are dates in the same format? I took into account DATE1 and DATE2 as fields, is that correct?

Regarding in set analysis coding

qliksus — Wed, 23 Dec 2009 16:06:55 GMT

hi,

Both are fields. Ans both are same format because if they are bot in same format then how output is coming when i write COUNT(DISTINCT IF(DATE1=DATE2,CODE)0

Regarding in set analysis coding

Miguel_Angel_Baeyens — Wed, 23 Dec 2009 16:36:48 GMT

You can try

Count({< STOCKQTY = {">0"} >} DISTINCT IF(DATE1 = DATE2, STOCKCODE))

Avoiding that failure in set analysis.

Regarding in set analysis coding

qliksus — Wed, 23 Dec 2009 17:12:08 GMT

Hi Miguel,

It's working fine. Thanks for your reply.