topic Re: TOTAL in script in QlikView

TOTAL in script

Anonymous — Mon, 19 Dec 2011 19:16:16 GMT

Hi there,

Who knows how can I add TOTAL?

I have expression in script

If(Value='A','A',If(Value='B','B',If(Value='C','C',If(Value='D','D',If(Value='E','E')))))as Value1

I need to add TOTAL in Value1.( A,B,C,D,E)

Thanks,

swuehl — Tue, 20 Dec 2011 00:22:09 GMT

Please see my answer in http://community.qlik.com/thread/40963, seems like the same question to me.

Anonymous — Wed, 21 Dec 2011 14:55:49 GMT

I need show TOTAL with other Value in a chart.

In the chart should be

TOTAL (A,B,C,D,E) and A, B.

Please find attached my report.

brenner_martina — Wed, 21 Dec 2011 15:00:17 GMT

Hi,

you can use the function sum by loading data with Group by

Greetings from Munich

Martina

EVACO GmbH

Anonymous — Wed, 21 Dec 2011 16:06:27 GMT

Hi Martina,

Thank you for your reply. Will I able to use my sum in a chart together?

Could you send me example in script?

Thank you again,

Anonymous — Wed, 21 Dec 2011 19:25:35 GMT

In Dimension Limits Tab check Show TOTAL
It shows TOTAL