topic Re: Latest 25 MOnths data in straight Table in QlikView

Latest 25 MOnths data in straight Table

Tue, 10 Nov 2015 07:49:18 GMT

Hi team,

please let me know the solution If we need the last 10 months latest data in the straight table.

Please suggest

Regards

miguelbraga — Tue, 10 Nov 2015 11:04:04 GMT

Hi Nikhil again,

Please see these threads:

Or use this expression:

For latest 10 monhts:

=Sum({<Date={">=$(=MonthStart(AddMonths(Max(Date),-10)<=$(=MonthEnd(AddMonths(Max(Date),-1)))"}>} Case)

For latest 25 months:

=Sum({<Date={">=$(=MonthStart(AddMonths(Max(Date),-25)<=$(=MonthEnd(AddMonths(Max(Date),-1)))"}>} Case)

Hope it solved your problema

Thanks,

miguelbraga — Tue, 10 Nov 2015 11:19:24 GMT

Also, a friendly advice for you:

Your title and question don't match, next time please take special care

Thanks and have a good Tuesday,

Kushal_Chawda — Tue, 10 Nov 2015 11:22:32 GMT

Create the Field MonthYear in script using Monthname function so that expression will become simple

Monthname(Date) as MonthYear

Now write below expression in chart to display last 10 months data

=sum({<MonthYear={">=$(=addmonths(max(MonthYear),-9))<=$(=max(MonthYear)))"}>}Cases)