topic Re: Do a relative sum for each unit in QlikView

Do a relative sum for each unit

Mon, 24 Sep 2012 12:30:34 GMT

i did a bar graf and put a measure sum(time) and mark relative ( to see the precent type from the total)

if i choose one unit it work ok.

but when i choose two unit, it takes the sum total(time)of the two units together and then present the precent type ,which is wrong .

i need it to consider each unit and it's sum .

is there is a way ?

i attached photo

thank you

swuehl — Mon, 24 Sep 2012 12:35:17 GMT

Instead of checking the relative box, try using an expression like

=sum(time) / sum(TOTAL<unit> time)

if unit is the dimension you are using for your units.

Mon, 24 Sep 2012 12:46:13 GMT

the unit is the one of the dimension (unit, type).

sorry but i did not uderstand the syntax ?

swuehl — Mon, 24 Sep 2012 12:54:08 GMT

Please check the HELP, sum() function and TOTAL qualifier with field list.

Mon, 24 Sep 2012 13:03:40 GMT

sorry you were right , i looked in the help for TOTAL but i did not find.

it was under SUM.

thank you