Discussion Board for collaboration related to QlikView Deployment.
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( TOTAL HOURS)
so how can I make it relate to the TOTAL in just the month (one of the dimensions)?
Thanks in advance,
Go to Solution.
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,
Thank you Jason, and apologies for the delayed response.
It is just what I was looking for.