topic Re: Read only the current 3 years of data using a variable (No hard-coding) in QlikView

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

Nagaraju_KCS — Wed, 05 Jun 2013 11:18:11 GMT

Hi All,

Please explain anyone...

Thanks in Advance....

Wed, 05 Jun 2013 12:37:27 GMT

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

Nagaraju_KCS — Wed, 05 Jun 2013 13:03:29 GMT

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..

Wed, 05 Jun 2013 13:07:03 GMT

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

Nagaraju_KCS — Wed, 05 Jun 2013 14:25:50 GMT

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

Wed, 05 Jun 2013 16:48:04 GMT

Hi,

today() - 1095

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

Rebeca