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

Pivot percentages for current month

I'm working on a Pivot table and need to show percentages through an expression. The below formula works perfectly to achieve what I wish when applying it to the dataset in my pivot table.

Count(ID)/ Count (TOTAL ID)

I have another column that totals data for the previous month using the following formula in an expression:

sum(InMonth(ComplaintDate,TODAY(),-1))*-1

I'd like to calculate the percentage for the previous month similar to the way I did it above, but when I create the below expression, it doesn't work.

 

(sum(InMonth(ComplaintDate,TODAY(),-1))*-1)  / (sum(TOTAL InMonth(ComplaintDate,TODAY(),-1))*-1 )

What am I missing?

Thanks in advance for any help you can provide.

1 Reply
Gysbert_Wassenaar