Pivot percentages for current month

Wed, 24 Dec 2014 16:11:34 GMT

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.

Re: Pivot percentages for current month

Gysbert_Wassenaar — Wed, 24 Dec 2014 17:07:54 GMT

Please read these two documents:

QlikCommunity Tip: How to get answers to your post?
Preparing examples for Upload - Reduction and Data Scrambling

topic Re: Pivot percentages for current month in QlikView

Pivot percentages for current month

Re: Pivot percentages for current month