topic time based filter in QlikView

time based filter

Thu, 06 Jan 2011 00:17:12 GMT

Hello,

I am trying to figure out the best way of implementing a time based filter. The data is at a monthly level, but I would like to create a filter that would show data for the Last 3 Months, Last 6 Months, Last 12 Months, Last 18 Months and Last 24 Months.

I thought of doing this in the Load script by tagging each record based on today's date - but found a few issues with that. I also considered dynamically evaluating that in the expression of the graph, based on a value selected by the user in the list box, created from an INLINE table .That also didn't seem to be the best way of doing this.

Any thoughts/ideas for accomplishing this?

Thanks, Maria

time based filter

maneshkhottcpl — Thu, 06 Jan 2011 04:33:39 GMT

Hi Maria,

u can use the inmonth function in backend and create a 3 months bucket.

or use mod function to create a bucket of 3 month like 3,6,9,......

if u send me the sample data i can surly help u.

Thanks

Manesh

time based filter

Fri, 07 Jan 2011 23:29:36 GMT

Manesh,

thanks for the offer. I convinced the users to just have a filter for Month.

Thanks, Maria

time based filter

Oleg_Troyansky — Sat, 08 Jan 2011 00:18:48 GMT

Maria,

I usually solve those problems in the script, adding an extra field to the Master Calendar. What issues have you had with that?