PV8
PV8

Reputation: 6280

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.

Upvotes: 0

Views: 1183

Answers (1)

The Budac
The Budac

Reputation: 1633

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

Upvotes: 1

Related Questions