TOTAL in script

[Anonymous]

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]

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

[Anonymous]

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]

Hi,

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

Greetings from Munich

Martina

EVACO GmbH

[Anonymous]

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 · Accepted solution]

In Dimension Limits  Tab check Show TOTAL
It shows TOTAL