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

[#1]

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

[MK_QSL]

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

Load * From TableName

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

[#3]

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)

[its_anandrjs]

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( );

or

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)

[jagan]

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.

[#6]

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

[#7]

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.