topic Re: Dividide column by Total in QlikView

Dividide column by Total

Wed, 29 May 2013 12:24:48 GMT

Hello ,

I am using Qv 11 .

I have 4 column in dimension side .& i want expression to divide each value of

column [ total in sale] in experrsion side by total of 1st dimension.

Dimension Exp

Segment Total in Sales % total

i tried it like this

num([total in sale] / sum (total <segment> [total in sale] ),'#,##0')

but it dident work

pls help

Gysbert_Wassenaar — Wed, 29 May 2013 12:29:58 GMT

You can try this: num(sum([Total in Sales])/sum(total <Segment> [Total in Sales]),'#.0%')

Or you can copy the Total in Sales expression and enable the Relative option.

Wed, 29 May 2013 12:35:34 GMT

sum([Total in Sales]) / sum(total [Total in Sales])

Wed, 29 May 2013 12:36:49 GMT

Thank u Sir

I tried u r 1st option but it didn't work . sa per u r 2 option what is mean by "relative option" can u pls explain

er_mohit — Wed, 29 May 2013 12:45:29 GMT

Try this

sum(aggr(sum([ total in sale])/ sum (total [total in sale] ),segment))

and in Number tab on that expression fixed to 2 and check on %

hope it helps