topic Condition pivot table expression on a dimension in QlikView

Condition pivot table expression on a dimension

canmarroig — Mon, 20 Feb 2017 12:21:24 GMT

Hi, i need to condition a column in a pivot. The yellow one, calculated only if dimension is = DIM 2

How can i do it. I've tried to flag and insert in condition box DIM='DIM 2' but X column doesn't appear

Tks

Anil_Babu_Samineni — Mon, 20 Feb 2017 12:31:26 GMT

What formula you want to implement for X?

canmarroig — Mon, 20 Feb 2017 13:39:48 GMT

I want to calculate delta%

Anil_Babu_Samineni — Mon, 20 Feb 2017 15:38:35 GMT

I will explain you clearly,

1) Create pivot chart

2) Use dimension as A, S.No, ValueList('DIM1','DIM2','DIM3')

3) Create Expressions like

i) Sum(A)

ii) Sum(B)

iii) Sum(DELTA)

And then use finally

If(ValueList('DIM1','DIM2','DIM3') = 'DIM2', Sum(DELTA)) // Then use Relative

If(ValueList('DIM1','DIM2','DIM3') = 'DIM2', (Sum(DELTA)/Count(DELTA)))