Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

RohanPR
New Contributor

Re: Calculate Previous Month Value based on Filter Selection

again thanks for all your help Smiley Happy

RohanPR
New Contributor

Re: Calculate Previous Month Value based on Filter Selection

Hi Sunny,

I am reopening this discussion again. I am facing a peculiar problem. When I do the calculation you provided in a text box I get a different number for both current month as well as for previous month. However, when I plot it on a graph either as a table or bar chart I get the exact correct numbers which is there in my excel. Jut to give some more context, the account numbers repeat in a month. Any reason why this is happening? My account number gets linked with other tables. However, that is not causing the problem since the table chart gives me exact numbers but in the text box I get a different number..

I need count(Account Number) every month and not count(distinct Account Number) in the text box.  I tried count(Account Number) in the text box calculation, however it doesn't count duplicate values

Regards,

Rohan 

Re: Calculate Previous Month Value based on Filter Selection

Would you be able to share a sample where we can see the issue?