topic If to Set analysis in QlikView

If to Set analysis

Tue, 08 Jan 2013 16:13:38 GMT

I am having problem to convert this expression to Set analysis......Thanks

=count(if(CDE <> null() and (TYPE_CDE = '00001' OR MAC_CDE = null()) and STATUS <> 'CANCEL' and REQUEST= 1,ORDER))

Re: If to Set analysis

Tue, 08 Jan 2013 17:00:30 GMT

HI,

For the condition (TYPE_CDE = '00001' OR MAC_CDE = null()), I recommend to create a flag in the script, something like:

select *,

if(TYPE_CDE = '00001' OR isnull(MAC_CDE),1,0) as Flag_CDE

from ...

Then the expression should be:

count({$<CDE={*},STATUS-={'CANCEL'},REQUEST={1},Flag_CDE={1}>} ORDER)

Hope this helps

Regards!

Re: If to Set analysis

CELAMBARASAN — Tue, 08 Jan 2013 17:04:23 GMT

Try this

Count({<CDE={*},TYPE_CDE={'00001'}, STATUS={*}, REQUEST={1}> + <CDE={*},MAC_CDE-={*}, STATUS={*}, REQUEST={1}>} ORDER)

Re: If to Set analysis

Tue, 08 Jan 2013 17:51:04 GMT

Thankyou Celembarasan, I am bit confused......Actually I am having lot of conditions but I mentioned the key conditions where I was having problem.....for representing OR condition Is this the only way, need to specify all the conditions again....Thanks

Re: If to Set analysis

Anonymous — Tue, 08 Jan 2013 18:09:57 GMT

The way to handle OR condition suggested by Gabriela allows to avoid repeating all over again. Apparently you need to modify the script in this case.

Regards,

Michael