Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I know this topic has been discussed many time and I have gone through each and every post. However, I am unable to get previous month value (count of account number) for the current year in my data set. The sample of my data set is given below
Month_Production , Acc_No, Category
Jan -18 , 123456,E
Jan-18, 234567,E
Jan-18, 123567,E
Feb-18, 246801, E
Feb-18, 357680,E
Mar-18,786502,E
Jan-18, 234590, P
Jan-18, 349086,P
Jan-18, 124509,P
Feb-18, 567890,P
Feb-18, 788090,P
Feb-18, 890877,P
E.g. 1 If I select category E and Month_Prod as Feb-18 from the multi drop down filter then the Prev month count for account number should display 3
E.g. 2 If I select category E and Month_Prod as Mar-18 from the multi drop down filter then the Prev month count for account number should display 2.
PS: I wan to display the number in the text box in front end. I used set analysis but didn't end up with right answer. Looking forward to a quick TAT. Thanks in advance
Thanks and Regards,
Rohan
again thanks for all your help
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
Would you be able to share a sample where we can see the issue?
Hi Guys - i am new to qlik sense - i have the same issue - i want previous month KPI to be based on filtered selection. e.g. if i select June i want previous month(May)figures to show - can someone please help ??