topic SVariable total function in QlikView

SVariable total function

vikas_nandanwar — Fri, 30 Mar 2018 11:10:09 GMT

Hi,

I have created SVariable 'mfg'

I have assigned 2 alternatives as

mfg = sum(Cts)

mfg = sum(Value)

I want to use % on total as -

1. - Sum(Cts)/Sum(Total Cts)

2. - Sum(Value)/Sum(Total Value)

My expression is not working.

$(mfg)/total$(mfg)

Thanks

Vikas

jwjackso — Fri, 30 Mar 2018 11:57:53 GMT

Try something like this:

Let vPct = 'Sum($1) / Sum(Total $2)';

DataSet1:
LOAD * Inline [
Dept,Val
D101,100
D101,200
D102,300
D102,400
D103,500
];

vikas_nandanwar — Sat, 31 Mar 2018 03:25:25 GMT

This do not work.

One of the chart uses pure sum as the measure

I have attached the screen shot.

Thanks

Vikas