topic Re: Current Month % Of Total in QlikView

Current Month % Of Total

dmac1971 — Fri, 19 Dec 2014 11:02:09 GMT

I have a straight table showing top 10 values by a dimension for the current month. This works fine :

sum({<Year={$(=year(today()))},MonthNum={'$(=upper(Month(today())-1))'}>}Value)

I want to then work out the % of the current month for each of the lines, trying to use this but it only returns 100% ? :

sum({<Year={$(=year(today()))},MonthNum={'$(=upper(Month(today())-1))'}>}Value)/sum({$<Year={$(=year(today()))},MonthNum={'$(=upper(Month(today())-1))'}>}Value)

Any idea where I am going wrong?

Re: Current Month % Of Total

sushil353 — Fri, 19 Dec 2014 11:15:52 GMT

Hi,

Try below expression:

sum({<Year={$(=year(today()))},MonthNum={'$(=upper(Month(today())-1))'}>}Value)/sum(Total {$<Year={$(=year(today()))},MonthNum={'$(=upper(Month(today())-1))'}>}Value)

HTH

sushil

Re: Current Month % Of Total

dmac1971 — Fri, 19 Dec 2014 11:18:19 GMT

Of course, DOH!!! Many thanks!