Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

we want torestrict straight table and want to show only 24 months from avaialbe 36 months fromtable

we have 1 requirement where data in straight table is look like this

id salesmonth
1100Jan-13
2200Feb-13
3300Mar-13
4400Apr-13
5500May-13
6600Jun-13
7700Jul-13
8800Aug-13
9900Sep-13
101000Oct-13
111100Nov-13
121200Dec-13
131300Jan-14
141400Feb-14
151500Mar-14

and 1st initial requirement is to show the data like data should display in a monthly columns@ and than restrict it for rolling 24months data from available 36 months..how this scenario is possible

id salesJan-13Feb-13Mar-13Apr-13May-13Jun-13Jul-13
1100
2200
3300
4400
5500
6600
7700
8800
9900
101000
111100
121200
131300
141400

kindly suggest

5 Replies
Specialist II
Specialist II

Hi virendra,

Try this expression in your chart,

=sum({<MonthNameField={">=$(=AddMonths(MonthNameField,-24)"}>}sales)

Hope it work for you.

-- Regards,

Vishal Waghole

Champion
Champion

=sum({<MonthNameField={">=$(=AddMonths(Max(MonthNameField),-24)"}>}sales)

Specialist II
Specialist II

Hey extremely sorry i forget to add Max(MonthNameField)

Champion
Champion

sum({<MonthNameField={">=$(=Date(AddMonths(Max(MonthNameField),-24),'MMM-YY'"}>}sales)

Contributor II
Contributor II

sorry to say but this set analysis will help me find out the rolling sum of data .but i want individual presence of the 24 months and data should visible accordingly.

i dont want rolling some  data for last 24 months.

i want to show last 24 columns without any current selections.