topic Re: How to add % of Total in a Pivot Chart in QlikView

How to add % of Total in a Pivot Chart

Anonymous — Tue, 14 Oct 2014 17:57:24 GMT

I have what seems to be a very basic data cross-tab table to be built, but yet have not found a way to do this easily with QVW.

I have created a basic cross tab, Sales by Product (row) and Year (column). How do I add % of Total in this table, with total being total for a year?

I have attached the sample QVW. Any help would be greatly appreciated!

Tue, 14 Oct 2014 18:14:04 GMT

Hi Sau,

Try this:

sum(Sales)/sum(TOTAL<Year> Sales)

See attached for more details.

Best,

Matt

Wed, 15 Oct 2014 18:41:20 GMT

Hi Sau,

Did that work for you?

Best,

Matt

ecolomer — Wed, 15 Oct 2014 19:00:10 GMT

Here you have an example

Anonymous — Wed, 15 Oct 2014 19:02:24 GMT

Thank you very much! That worked too!

Anonymous — Wed, 15 Oct 2014 19:03:04 GMT

Thank you for the speedy response Matt! It worked like a charm...

Much appreciated,

Anonymous — Wed, 15 Oct 2014 19:43:19 GMT

Let me throw you a zinger. What if my Year dimension is a drill-down group that has Year, Quarter, Month?

Or, actually what if the column has nested columns Year, Quarter, Month, that you can drill in, or expand (instead of a group)?

How can I make the formula dynamic to know the group level?

Thanks again,

Anonymous — Wed, 15 Oct 2014 19:45:13 GMT

I replied to my original post, but what if my Year dimension is a drilldown group that looks like this: Year, Quarter, Month?