Discussion Board for collaboration related to QlikView App Development.
we have 1 requirement where data in straight table is look like this
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
Try this expression in your chart,
Hope it work for you.
Hey extremely sorry i forget to add Max(MonthNameField)
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.