topic Percentag calculation based on a line in QlikView

Percentag calculation based on a line

bumin — Sun, 20 Mar 2011 22:29:38 GMT

I have to create a table with a percentage column

the percentage in every line is calculated based on the line "revenue total" : current line / revenues total

can anyone give me a hint how to do it?

Miguel_Angel_Baeyens — Mon, 21 Mar 2011 07:00:53 GMT

Hello,

If the "account" displayed above is a dimension, you might try something like the following

Sum(value) / Sum({1< account = {'revenues total'} >} TOTAL value)

Hope that helps.

EDIT: Checked syntax

bumin — Tue, 22 Mar 2011 03:31:34 GMT

Thanks Miguel,

works perfectly

kind regards

Bumin