topic Set analysis OR instead of AND in QlikView

Set analysis OR instead of AND

frankhuning — Mon, 31 Jan 2011 14:09:05 GMT

Hi all,

Maybe a simple question for you developers but for me it's quit difficult as a newby.

My pivottable has an expression like:

Sum

( {$< PROJGROUPID = {"GENERAL"}, CATEGORYID = {"ZZGEN"} >} QTY)

What I try to achieve is the sum of all records where RPOJGROUPID = "GENERAL" OR CATEGORYID ="ZZGEN".

Thanks in advance for your help.

Regards,

Frank

Mon, 31 Jan 2011 14:18:51 GMT

Hi,

You can try this,



Sum( {$< PROJGROUPID = {'GENERAL'}>} QTY) +
Sum( {$<CATEGORYID = {'ZZGEN'} >} QTY)

kuba_michalik — Mon, 31 Jan 2011 17:10:08 GMT

Or you could use sum of sets:

Sum( {$< PROJGROUPID = {"GENERAL"}>+$<CATEGORYID = {"ZZGEN"} >} QTY)

I have no idea whether this is an aesthetic choice, or if it has some performance implications.