Search code examples
qlikviewqliksense

Percentage of Total per Product group in qlikview


I have a table which looks like this:

Group Value Month
A     100   1
A     150   2
B     50    1
B     100   2

what is the right expression to have a formula in qlikview to have this later in a lineplot, where the x-axis is the month , the y-values are the values in % of the total per month and the groups are the groups.

Right now I have:

Sum(Value)/Sum(total <Value> [Month])

which is not working.


Solution

  • sum(Value)/sum(total <Month> Value)
    

    You want to group the denominator by Month not add up the months per Value

    enter image description here