Columns in Pivot chart

marwen_garwachi — Thu, 20 Nov 2014 16:23:41 GMT

Hello,

I have a Pivot chart wich contains 4 lines (A,B,C,D) calculated in dimension (If Field = 1 ,A, If Field = 2, B etc....) i need to calculate an expression :

If dimension value = A then score = Field_A *2

If dimension value = B then score = Field_A *4

if dimension value = C then score = Field_A *6

if dimension value = D then score = Field_A *10

How can i do it ?

Dimension	Score
A
B
C
D

Thanks for your help

Re: Columns in Pivot chart

marwen_garwachi — Thu, 20 Nov 2014 16:29:27 GMT

I found it ! i've tried this expression and it works

If rowno() = 1, Field_A *2,

If rowno() = 2, Field_A *4,

If rowno() = 3, Field_A *6

If rowno() = 4 Field_A *10

Thanks to me

topic Columns in Pivot chart in QlikView

Columns in Pivot chart

Re: Columns in Pivot chart