Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get the previous month count

How to get the previous month count, as per attached example need the previous month (Mar’15) count in current month (Apr’16) for the same department


Please Help. Thanks in advance

15 Replies
Not applicable
Author

I am still not able to get correct values. Need Mar'15 values in Apr'16 for the specific department.

Please help. Thanks for your effort and time.

sunny_talwar

Last years previous values?

Not applicable
Author

Hi Sunny,


Absolutely right. Please help with the same.Thanks

pho3nix90
Creator II
Creator II

The solutions thus far is to use inter record functions within the chart, it seems you are using a financial calendar and thus year starts on April, to show the previous value for April you will need to display March in the table as well for the current solutions.

What you need is for the calculations to be done in script. Please upload the "Tes.xlsx" so that I can give you another example.

Not applicable
Author

Hi Shaun,

You are right. Please find the attached excel data for your reference.

Thanks for your support.

pho3nix90
Creator II
Creator II

Please see attached