Discussion board where members can get started with QlikView.
I have a mekko chart and I would like to show each bar/column in the chart as totalling 100% so that the first bar shows the values 75% and 25% respectively for the underlying counts 15 and 5 (currently they show 1500% and 500% - see qvw attached)
Thanks in advance for any help,
Go to Solution.
its not that simple
but if you are determinated to do this you can do a little trick
=sum(Ticket_Count)/sum(total <Country> Ticket_Count)
as an expression
is that what you want?
Thanks Pari Pari, just what I needed.