topic Re: How to limit table to show data only from certain date? in QlikView

How to limit table to show data only from certain date?

Wed, 16 Apr 2014 19:18:03 GMT

(Date is a column in this table). I'm really newbie at this, sorry!

Re: How to limit table to show data only from certain date?

MK_QSL — Wed, 16 Apr 2014 19:19:29 GMT

If you want data starting from 1st January 2014....

Load * From TableName

Where Date >= '01/01/2014';

Re: How to limit table to show data only from certain date?

Thu, 17 Apr 2014 03:19:15 GMT

As Manish said you can limit your data from load script.

Another option is that you can limit data from expression in your chart, in case you just want to limit the single table while keep full data. Use set analysis to limit data in your chart expression. Like Sum({$<Year={ '>=2013'} >}Value)

Re: How to limit table to show data only from certain date?

its_anandrjs — Thu, 17 Apr 2014 03:43:51 GMT

By loading of data you can limit by loading minimum data like

Load

Date

From Location

Where Date >= 'From date' and Date<='To date';

Eg:-

Load

Date

From Location

Where Date >= '01/01/2013' and Date <= Today( );

Load

Date

From Location

Where Date >= '01/01/2013' and Date <= '31/12/2013';

or script you can do like

Sum({$<Date >= {'01/01/2014'}>} Value)

Re: How to limit table to show data only from certain date?

jagan — Thu, 17 Apr 2014 04:30:29 GMT

Hi,

It is not possible to restrict data in Table box, it always displays based on the selections. If you want to restrict then use Straight or Pivot tables, and use set analysis to restrict the data.

Use set analysis something like below

For displaying Current Date (Today) data:

Sum({$<DateDimensionName={'>=$(=Today())'}> } Value)

Current Month:

Sum({$<DateDimensionName={'>=$(=MonthStart(Today()))<=$(=Today())'}> } Value)

Previous Month:

Sum({$<DateDimensionName={'>=$(=MonthStart(Today(), -1))<=$(=MonthEnd(Today(), -1))'}> } Value)

Current Quarter:

Sum({$<DateDimensionName={'>=$(=QuarterStart(Today()))<=$(=Today())'}> } Value)

Current Year:

Sum({$<DateDimensionName={'>=$(=YearStart(Today()))<=$(=Today())'}> } Value)

Hope this helps you.

Regards,

Jagan.

Re: How to limit table to show data only from certain date?

Thu, 17 Apr 2014 04:53:12 GMT

Hi,

Set Analysis is better option. But, it will be hardcoded.

If you want to increase the limit, every time you have to go to extraction and change.

If i define in excel and then load, will it be ok.

Regards

Amol Khochare

Re: How to limit table to show data only from certain date?

Thu, 17 Apr 2014 05:25:23 GMT

You can put your variable in excel, modify it before reload.

Or you can define a variable in script, and link that variable to a slider object. then you can pick data dynamically without reloading. Ofcourse you need to load all data in at very beginning.