Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for
Did you mean:
Partner - Creator

## Condition pivot table expression on a dimension

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

3 Replies

What formula you want to implement for X?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Partner - Creator
Author

I want to calculate delta%

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

Or

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Community Browser