topic Variable in Set Analysis in QlikView

Variable in Set Analysis

Fri, 01 Nov 2013 17:15:07 GMT

Good morning,

I am trying to do a set analysis calculation, and i'm running into some trouble.

This one seems to work:

count( {$< CustomerSales = {"<=$(#vTier1)"} >} DISTINCT [WH Customer])

But when i add a second variable in there, to say greater than tier 1 but less than tier 2, it doesn't work.

count( {$< CustomerSales = {">$(#vTier1)"}, CustomerSales = {"<=$(#vTier2)"}>} DISTINCT [WH Customer])

Not sure why this one doesnt work...

Much thanks,

-David

Fri, 01 Nov 2013 17:15:43 GMT

I'm trying to count the distinct customers whose sales are greater than Variable vTier1 but less than Variable vTier2

Gysbert_Wassenaar — Fri, 01 Nov 2013 17:40:28 GMT

Try it like this: count( {$< CustomerSales = {">$(#vTier1)<=$(#vTier2)"}>} DISTINCT [WH Customer])

Fri, 01 Nov 2013 17:43:08 GMT

Great! This works!

Is my method a possible way to do this as well?

Gysbert_Wassenaar — Fri, 01 Nov 2013 17:51:57 GMT

Nope. Well, you could do it like this:

count( {$< CustomerSales = {">$(#vTier1)"}> * <CustomerSales = {"<=$(#vTier2)"}>} DISTINCT [WH Customer])

But it is less clear imho and could perform worse too since first two sets are calculated and then intersected with each other.

Fri, 01 Nov 2013 17:52:56 GMT

Much Much appreciated!