Pivot Table and Variable in Set Analysis

sparur — Tue, 07 Dec 2010 08:12:59 GMT

Hello, guys.

I have some problems with my pivot table. I hope you can help me... 🙂

If you look at my qvw example you will see, that I want to calculate EANs, which should have ROS >= Median of ROS. (see in first expression of my pivot):

count({<[ROS]={">= $(vROSMedian)"}>} [EAN]),

where vROSMedian =Round(MEDIAN({<[Manufacturer] =}>}[ROS]))

Problem is in the variable vROSMedian. this variable calculate by current selections, but not by pivot dimensions (as I want).

ROSMedian should calculate by Time and by Sales Channel and if you will see in second expression, you will see the correct value of ROSMedian.

but now if you look at the header of first expression, you will see, that vROSMedian = 751 for all lines. It's not correct.

so count of EANs isn't correct also 😞

But If I select one Time and one Sales Channel - I will get correct numbers in first expression:

How I can resolve my problem? I want get correct numbers without selections in [Time] and [Sales Channel] fields.

I will be glad to hear any ideas, thanks

Pivot Table and Variable in Set Analysis

sparur — Wed, 08 Dec 2010 07:05:39 GMT

No ideas? 😞

Pivot Table and Variable in Set Analysis

Fri, 20 Jan 2012 21:06:56 GMT

Variables are calculated before applying pivot dimensions. If you need pivot dimensions applied you should not use variables with expressions that depend on pivot dimensions.

Try using direct expressions instead of variables, if possible.

topic Pivot Table and Variable in Set Analysis in QlikView

Pivot Table and Variable in Set Analysis

Pivot Table and Variable in Set Analysis

Pivot Table and Variable in Set Analysis