topic Inclusing and Excluding data using Set Analysis in QlikView

Inclusing and Excluding data using Set Analysis

deepakk — Fri, 12 Nov 2010 12:35:58 GMT

Hi All,

I have data with Three fields Product, Category and Qty. I need to see sum of Qty where Product = A and Category <> ABC.

I have achieved the same using If statement but I want to use Set analysis to achieve the same.

I am attaching a sample application.

Please provide you valuable inputs on the same.

SV:Inclusing and Excluding data using Set Analysis

gandalfgray — Fri, 12 Nov 2010 13:02:42 GMT

This is one way to do it:

Sum({$<Product={'A'}> - 1<Category={'ABC'}>} Qty)

SV:Inclusing and Excluding data using Set Analysis

deepakk — Fri, 12 Nov 2010 13:10:25 GMT

cool thanks Goran

SV:Inclusing and Excluding data using Set Analysis

johnw — Fri, 12 Nov 2010 20:10:23 GMT

This should be a little more efficient since it's only one set instead of one set minus another set. Probably won't make much practical difference, though.

sum({<Product={'A'},Category-={'ABC'}>} Qty)

Inclusing and Excluding data using Set Analysis

Wed, 02 Nov 2011 09:50:21 GMT

Thanks you John, i was looking for something similar (for +10 categories).

My application is like this (just if someone needs to exclude/include more items)

sum({<Product={'A'},Category-={'ABC','XYZ'}>} Qty) // excludes 'ABC','XYZ', leaved everything else

sum({<Product={'A'},Category={'ABC','DEF'}>} Qty) // show only ABC and DEF

very clean and usefull

thanks,

Alex