Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
qv_testing
Specialist II
Specialist II

Read only the current 3 years of data using a variable (No hard-coding)

Hi All,

Please explain anyone...

  • Read only the current 3 years of data using a variable (No hard-coding)

Thanks in Advance....

5 Replies
Not applicable

Hi,

You could not use the date of recharge function Today () - in your where? Something like below:

WHERE DAT> Date (today () -1095, 'DD / MM / YYYY')

Rebeca

qv_testing
Specialist II
Specialist II
Author

Hi Rebeca,

Please find my attachment table..

in my table i have 2003,04,05,06 and 2007 years data.

Read only the current 3 years of data using a variable (No hard-coding)

how to get please explain.....

Thanks in Advance..

Not applicable

Hi,

Create a variable and assign the maximum year to it.

Then while loading the data load only last 3 years data...ex: variable-3

Regards,

Amay

qv_testing
Specialist II
Specialist II
Author

Hi,

if i am using today() function it returns 2013.

but i have years 03,04,05,06 and 07 years.

how can i get year

Not applicable

Hi,

today() - 1095

will show the date three years ago, 365 for each year.

Rebeca