# QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Contributor II

## Current Month % Of Total

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?

1 Solution

Accepted Solutions
Honored Contributor II

## Re: Current Month % Of Total

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

2 Replies
Honored Contributor II

## Re: Current Month % Of Total

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

Contributor II

## Re: Current Month % Of Total

Of course, DOH!!!  Many thanks!