Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How to ignore one dimension during aggr

I have a chart with 2 dimensions - CalendarMonthName, Region

For each month, i want to show breakdown of revenue across regions. As such for every month, the % across regions should add upto 100%

I added expression like these -

sum(NET_COMMS)

sum(total aggr(sum(NET_COMMS),CalendarMonthName))

column(1)/column(2)

But with this logic, 2nd column does not show total of the revenue for each month across regions. Instead it shows the total of for all months.

Please refer to attached image for details...

% amount for 4 regions for Jan. 2011 should add upto 100%

and % amount for 4 regions for Feb. 2011 should also add upto 100%

Can someone help me with correcting the expressions... thanks in advance!

1 Solution

Accepted Solutions
Not applicable

Re: How to ignore one dimension during aggr

Hi,

Can you try the below one:

sum(NET_COMMS)/sum(TOTAL <CalendarMonthName> NET_COMMS)

Kiran.

2 Replies
Not applicable

Re: How to ignore one dimension during aggr

Hi,

Can you try the below one:

sum(NET_COMMS)/sum(TOTAL <CalendarMonthName> NET_COMMS)

Kiran.

Not applicable

Re: How to ignore one dimension during aggr

thanks! it worked fine!