topic filter on date in QlikView

filter on date

Fri, 15 Aug 2014 10:42:02 GMT

As part of the load process is it possible to easily restrict the dates the data loads for? So for example, if i only want it to load a year, or a month at a time?

Thanks

Re: filter on date

Colin-Albert — Fri, 15 Aug 2014 10:46:44 GMT

Unless you are dealing with massive data sets it is better to load all data and let your users filter the data using list boxes for Year & Month.

You can add a sheet trigger to set an initial selection or use bookmarks.

Re: filter on date

MK_QSL — Fri, 15 Aug 2014 10:47:28 GMT

Load * From TableName

Where Date >= Date('01/01/2014','DD/MM/YYYY') ;

Load * From TableName

Where Year >= 2014;

Re: filter on date

Fri, 15 Aug 2014 10:49:56 GMT

yeah thats what I have done is to load everything and then use the year,quarter and month dims for filter criteria.

In my load script I have set it such that it loads >2012 based on client requirements.

I am dealing with alot of data.

Re: filter on date

maleksafa — Fri, 15 Aug 2014 10:55:29 GMT

you can do that from the script when loading the data by setting a condition on the year like year >= 2012 or do it dynamically year >= addyear(today(),-2)

Re: filter on date

MK_QSL — Fri, 15 Aug 2014 11:00:25 GMT

There could be a possibility of Date formatting.

Let me know what exactly you want to load.

If possible, prepare a 10-15 lines dummy data in excel file and provide what output you required.