topic Need Help in QlikView

Need Help

Anonymous — Wed, 15 Jan 2014 07:03:43 GMT

Hello All,

I am facing a problem in achieving the format attached below.

I want to show Last 3 months, Last 6 months and Last 12 months data along with all months data.

I know , we can concatenate 3 months , 6 months and 12 months data with original one which will give me the results.

But I dont want it , as the data size is very huge which will increase the data at huge extent.

I there any other way out.

Even writing all expressions for every month is my last option.

Wed, 15 Jan 2014 07:09:58 GMT

Hello

You can create set analysis expressions for last 3, 6 and 12 months like below:

variables:

vMaxSelectedCalendarDate=MonthStart(max(Trade.Date))

vLastThreeMonths = =addmonths(vMaxSelectedCalendarDate,-3)

expression for last 3 months:

count({<[Trade.Date] = {">=$(vLastThreeMonths)<$(vMaxSelectedCalendarDate)"},[Trade Month]=,[Trade Year]=,[Trade Quarter]=>}itemid)

Trade.Date is the calendar date.

Thanks,

Angad