Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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_michaelid
Honored Contributor II

Help with graph showing percentages

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

3 Replies
jason_michaelid
Honored Contributor II

Help with graph showing percentages

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

Help with graph showing percentages

Thank you Jason, and apologies for the delayed response.

It is just what I was looking for.

Matt

jason_michaelid
Honored Contributor II

Help with graph showing percentages

Coolio.

Community Browser