topic Re: latest and pervious year in QlikView

latest and pervious year

manoranjan_d — Wed, 03 Aug 2016 12:36:37 GMT

I having list of year from 2010 to 2016

in my qvd i want to retrieve the latest year and pervious year only

so i need 2016 and 2015 only

Re: latest and pervious year

sunny_talwar — Wed, 03 Aug 2016 12:38:13 GMT

May be this:

Max(Year) and

Max(Year) - 1

Re: latest and pervious year

Mark_Little — Wed, 03 Aug 2016 12:43:48 GMT

Hi,

Add a where clause in your loader.

from Data.QVD

WHERE Year >= 2015;

Mark

Re: latest and pervious year

manoranjan_d — Wed, 03 Aug 2016 12:53:34 GMT

how declare this in the variable

Re: latest and pervious year

sunny_talwar — Wed, 03 Aug 2016 12:54:33 GMT

If you want them as values, then use triggers, else just give the above as definition to your variable

Re: latest and pervious year

manoranjan_d — Wed, 03 Aug 2016 12:58:48 GMT

how to achieve this in the if loop condtion in the qvd generator

Re: latest and pervious year

Mark_Little — Wed, 03 Aug 2016 13:00:44 GMT

Hi,

I would need more information on your script and the loop in questions as you may be able to set it in variable and then increment it if needed. depend a lot of the script and what exactly you're trying to achieve

Mark

Re: latest and pervious year

manoranjan_d — Wed, 03 Aug 2016 13:02:42 GMT

i have field called year

now if i want to call that field only with current year and previous year

Re: latest and pervious year

Anil_Babu_Samineni — Wed, 03 Aug 2016 13:03:45 GMT

I am not sure, What is mean of Variable.

Perhaps this

SET vCurrYear = Max(Year);

SET vPrevYear = Max(Year) - 1;

Re: latest and pervious year

Mark_Little — Wed, 03 Aug 2016 13:06:32 GMT

Ok, but you mentioned a loop?

If you want it to be dynamic you could add a variable

LET vYear = YEAR(ADDYEARS(TODAY(),-1));

TABLE:

LOAD

Resident Location

WHERE Year >= $(vYear);

Mark

Re: latest and pervious year

manoranjan_d — Wed, 03 Aug 2016 13:27:00 GMT

while putting where condition this can be used in resident load?

Re: latest and pervious year

manoranjan_d — Wed, 03 Aug 2016 13:27:54 GMT

i assigned the variable and

while loading the qvd

laod *

from

xxx qvd

WHERE Year >= $(vYear);

it showing field not found

Re: latest and pervious year

vishsaggi — Wed, 03 Aug 2016 13:33:01 GMT

Try this.

LET vYear = Year(Today())-1 ;

Then load as below.

laod *

from

xxx qvd

WHERE Year >= $(vYear);