topic Re: Issue on percentages in QlikView

Issue on percentages

chinnu123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

I Have a Issue with showing Percentages in group bar chart. My Scenario is I am having field Category In that I am having values A,B,C

here what I want to show is 4 months rollings data in bar chart like A/(A+b+C) in the same way B/(A+B+C) in the same way C also

johnw — Tue, 26 Jul 2016 22:49:06 GMT

If I've understood, something like this:

Dimension 1 = Month
Dimension 2 = Category
Expression = sum(Something)/sum(total Something)

And set to accumulate 4 steps back.

sunny_talwar — Wed, 27 Jul 2016 02:04:55 GMT

In case what John has provided doesn't work out for you, would you be able to share some raw data with the expected output.

Best,

Sunny