topic Total sum in all records using calculated expression in QlikView

Total sum in all records using calculated expression

manideep78 — Fri, 25 Jul 2014 11:10:53 GMT

Dear All,

I have to have the sum of all values in a calculated expression in another column in a chart.

Eg:

Dim --> Month

Expr 1 --> =(10*20)+RowNo() .This gives me 201,202,203....212 for each month starting from Jan to Dec. and the sum of all of these gives 2478.

Expr 2 --> I want 2478 for each dimension. and this value should be calculated from Expr1.

see below Pic

Please let me know how can I achieve this?

Regards,

Manideep

Message was edited by: Manideep HV

amit_saini — Fri, 25 Jul 2014 11:13:45 GMT

Manideep,

I think variable will wok here.

Thanks,

manideep78 — Fri, 25 Jul 2014 11:21:04 GMT

Hi amit,

Can you please elaborate more?