topic IF to SET Analysis conversion question in QlikView

IF to SET Analysis conversion question

Thu, 08 Aug 2013 19:20:11 GMT

Hi Experts,

Is it possible to convert the follwing expressions into set analysis

max( if (ORD_DT <= '5/18/2007',ORD_DT))

COUNT(DISTINCT if (ORD_DT<= '4/18/2007', ORD_ID))

Thanks,

Aji Paul.

sushil353 — Thu, 08 Aug 2013 22:56:53 GMT

try this:

Count({<ORD_DT={"<=4/18/2007"}>} DISTINCT ORD_ID)

Max({<ORD_DT={"<=5/18/2007"}>} ORD_DT)

if "" (double quotes) doesn't work then try with '' (single quotes).

HTH

Sushil