Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help with graph showing percentages

hi all,

I have a graph which shows 3 percentages, by month.

At the moment, the percentages seem to be worked out on totals across ALL time - yet I need them specific to the month that is being shown.

If I select a particular month from a list box it is fine...

my expression is:

SUM(HOURS)

/

SUM( TOTAL HOURS)

simple enough..

so how can I make it relate to the TOTAL in just the month (one of the dimensions)?

Thanks in advance,

Matt

1 Solution

Accepted Solutions
Jason_Michaelides
Luminary Alumni
Luminary Alumni

Hi Matt,

TOTAL will remove all dimensions from the calculations, but you can put them back one by one.  Try:

SUM(HOURS)/SUM(TOTAL <Month> HOURS)

Hope this helps,

Jason

View solution in original post

3 Replies
Jason_Michaelides
Luminary Alumni
Luminary Alumni

Hi Matt,

TOTAL will remove all dimensions from the calculations, but you can put them back one by one.  Try:

SUM(HOURS)/SUM(TOTAL <Month> HOURS)

Hope this helps,

Jason

Not applicable
Author

Thank you Jason, and apologies for the delayed response.

It is just what I was looking for.

Matt

Jason_Michaelides
Luminary Alumni
Luminary Alumni

Coolio.