Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Header 1 | Header 2 |
---|---|
Account | Rating |
1001 | A |
1002 | A |
1003 | A |
1004 | B |
1005 | B |
Month=March
Header 1 | Header 2 |
---|---|
Account | |
1001 | A |
1002 | B |
1003 | B |
1004 | B |
1005 | B |
Month=April
Now I wants the count of account for april month who has Rating A in march month and change the rating from A to B in April month.In above example desired output is 2 as account(1002,1003) change the rating from A to B.
Its difficult, I need some time to solve this...
Check this out. I think it should solve your problem.
http://community.qlik.com/message/63017#63017
Best Regards,
Vishal
Thanks Vishal....
Is there any month field in your tables..
Yes, there is a month field and monthend id as well...
Try this it may helps you..
=Count(Aggr(Sum({<MonthField={"April"}>}Account),Rating))
nice!