Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Not applicable

How to find data based on the value of previous month and current month

Header 1Header 2
AccountRating
1001A
1002A
1003A
1004B
1005B

Month=March

Header 1Header 2
Account
1001A
1002B
1003B
1004B
1005B

  

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.

Tags (2)
7 Replies
Not applicable

How to find data based on the value of previous month and current month

Its difficult, I need some time to solve this...

Not applicable

How to find data based on the value of previous month and current month

Check this out. I think it should solve your problem.

http://community.qlik.com/message/63017#63017

Best Regards,

Vishal

Not applicable

How to find data based on the value of previous month and current month

Thanks Vishal....

Partner
Partner

How to find data based on the value of previous month and current month

Is there any month field in your tables..

Not applicable

How to find data based on the value of previous month and current month

Yes, there is a month field and monthend id as well...

Partner
Partner

How to find data based on the value of previous month and current month

Try this it may helps you..

=Count(Aggr(Sum({<MonthField={"April"}>}Account),Rating))

Not applicable

How to find data based on the value of previous month and current month

nice!