topic Re: Years in QlikView

Years

Mon, 23 Mar 2015 15:18:17 GMT

I have data with many years, but I only want to see the max year and max year - 1, max year - 2, max year - 3.

Can I make this in my script or on another place?

Thanks

Re: Years

Anonymous — Mon, 23 Mar 2015 15:23:04 GMT

I would do it in the load script using a suitable WHERE when loading the data.

Re: Years

buzzy996 — Mon, 23 Mar 2015 15:24:47 GMT

u can do in both the ways,

in ur script.

where yeardatefield>=(max(yeardatefield) -3)

Re: Years

sunny_talwar — Mon, 23 Mar 2015 15:26:22 GMT

You can restrict it within the script by creating a variable vMaxYear

Data:

LOAD fieldNames,

Year

FROM yourSource;

MaxYear:

LOAD Max(Year) as maxYear

Resident Data;

LET vMaxYear = Peek('maxYear');

DataTable:

NoConcatenate

LOAD *

Resident Data

Where Year >= ($(vMaxYear) - 3);

DROP TABLES Data, MaxYear;

HTH

Best,

Sunny

Re: Years

Mon, 23 Mar 2015 15:42:59 GMT

Thanks all!

But I now I don't want this, but in my data I have the years 2026,2088 can I exclude them?

Re: Years

sunny_talwar — Mon, 23 Mar 2015 15:44:35 GMT

You can do this to exclude anything after the year 2026

Where Year < 2026;

or you can exclude anything from next year forward:

Where Year <= Year(Today());

HTH

Best,

Sunny

Re: Years

Mon, 23 Mar 2015 15:48:35 GMT

Oke and this : Where Year < 2026; must I copy past in my script?

Re: Years

Mon, 23 Mar 2015 15:53:52 GMT

LOAD Number,
Year
FROM
Source

Or must i copy past it behind Year?

Re: Years

sunny_talwar — Mon, 23 Mar 2015 15:53:59 GMT

Ya i would paste it after the FROM/Resident statement in the table from which you want to exclude Year 2026 and beyond.

Re: Years

sunny_talwar — Mon, 23 Mar 2015 15:54:57 GMT

LOAD Number,
Year
FROM Source

Where Year < 2026;

Re: Years

Mon, 23 Mar 2015 15:57:27 GMT

Oh, I understand!

Thanks!

Sorry, I am not a QV pro

Re: Years

sunny_talwar — Mon, 23 Mar 2015 15:58:42 GMT

Not a problem. I am glad I was able to help.

Best,

Sunny

Re: Years

Tue, 24 Mar 2015 07:54:50 GMT

Thanks!