topic Value adding to other columns in QlikView

Value adding to other columns

priyarane — Mon, 23 Feb 2015 12:57:13 GMT

Hi I have a pivot chart and and my issue is Period - P0 value need to add to other Periods

Expr -

sum (Value)

Current Chart

Dim1 Dim2 Dim3 Dim4(Period) : P0 P1 P2 P3

A X TT 10 20 25 40

B Y ZZ 2 5 8 7

And The requirement is:

Dim1 Dim2 Dim3 Dim4(Period) : P0 P1 P2 P3

A X TT 10 30(P0+P1) 35(P0+P2) 50 (P0+P3)

B Y ZZ 2 7 10 9

Note - Dim4(Period) is dragged upwards.

Thank you

Re: Value adding to other columns

Anonymous — Mon, 23 Feb 2015 13:12:35 GMT

Hi Priya,

//initialize a variable for sum of P0 in script and try like this

LET varP0 = Peek('FieldName',0,Temp);

In chart:

if(Product='P0',sum(Value),sum(Value)+$(varP0))

Regards

Neetha

Re: Value adding to other columns

MK_QSL — Mon, 23 Feb 2015 13:16:19 GMT

Instead of using Period in Dimension tab... create below 4 expressions in Expression Tab

Expression

SUM({<Period = {'P0'}>}Value)

Lable

Expression

SUM({<Period = {'P0'}>}Value) + SUM({<Period = {'P1'}>}Value)

Label

Expression

SUM({<Period = {'P0'}>}Value) + SUM({<Period = {'P2'}>}Value)

Label

Expression

SUM({<Period = {'P0'}>}Value) + SUM({<Period = {'P3'}>}Value)

Label

Re: Value adding to other columns

sunny_talwar — Mon, 23 Feb 2015 13:22:21 GMT

Did you look at this similar post?

Chart Caluclation

and

Setanalysis to make field constant

Best

Re: Value adding to other columns

priyarane — Mon, 23 Feb 2015 15:12:22 GMT

Hi Manish,

I have tried it but the issue is, if we select Period(Filter) then for Ex- P1 then still we can see all periods.

Re: Value adding to other columns

Mon, 23 Feb 2015 15:50:41 GMT

Hi,

could you please attached an example qvw?

Re: Value adding to other columns

priyarane — Tue, 24 Feb 2015 08:31:00 GMT

Hi SunIndia,

Its similar kind of 'http://community.qlik.com/thread/151035'

Re: Value adding to other columns

priyarane — Tue, 24 Feb 2015 08:33:17 GMT

Hi Guys,

I got the answer with the help of 'http://community.qlik.com/thread/151035'

and the answer like below -

sum

(Value)
+if(Trad_PERIOD='P0',0,sum(TOTAL <Dim1, Dim2, Dim3> {<PERIOD={'P0'}>} Value))

Thank you all.