topic Set Analysis - Basic question about intersection operator (*) in QlikView

Set Analysis - Basic question about intersection operator (*)

Mon, 14 Feb 2011 21:05:50 GMT

I've read up on a few threads about this but haven't found the specific answer that I'm looking for. Basically, I'm trying this expression for a straight table:

= count({<[Gifts Type Code] = {c}> * <[Gifts Honor Marker] = {B}>} [Gifts ID])

and it yields 0. However if I use this

= count({<[Gifts Type Code] = {c}, [Gifts Honor Marker] = {B}>} [Gifts ID])

It works. My question is why? It seems like the two statements should yield identical results

Obviously for this specific case I can use the second statement, but I use the intersection operator (*) in several other places so I want to make sure I know what it actually does.

Thanks

Set Analysis - Basic question about intersection operator (*)

pover — Mon, 14 Feb 2011 21:56:49 GMT

The syntax looks fine, but I've found a difference in how each responds to user selections because if the user makes a selection of a [Gifts Hone Marker] that isn't B than the 2 sets don't intersect so

= count({<[Gifts Type Code] = {c}, [Gifts Honor Marker] = {B}>} [Gifts ID])

would be more like

= count({<[Gifts Honor Marker]=, [Gifts Type Code] = {c}> * <[Gifts Honor Marker] = {B},[Gifts Type Code]=>} [Gifts ID])

Regards.

Set Analysis - Basic question about intersection operator (*)

Mon, 14 Feb 2011 23:19:47 GMT

Thanks a lot, that's very helpful.