topic Re: How do we get max year values in QlikView

How do we get max year values

Wed, 25 Nov 2020 16:16:04 GMT

‌Hi all,

I have 2016 and 2015 years records in my table.

i Need to display only max year months datA in bar graph that too last 3 months

so I filter the data in script level where year(asofdt)>2015.

Then i am getting the bar with set analysis. As of now it is ok but

this application will get 2017 data, that time how to get max year values dynamically

PLease help help me to solve

Re: How do we get max year values

tresB — Tue, 07 Jun 2016 05:29:37 GMT

If you are looking for current year data, you can try like:

Where year(asofdt)=Year(today());

If it is dependent on data, you could create a variable like:

Load

max(asofdt) as MaxDt

From <>;

vMaxYear=Peek('MaxDt');

Then ..

Load

From <> Where year(asofdt)='$(vMaxYear)';

Re: How do we get max year values

varshavig12 — Tue, 07 Jun 2016 05:36:21 GMT

where year(asofdt)= max(Year(asofdt))

Re: How do we get max year values

sujeetsingh — Tue, 07 Jun 2016 05:51:01 GMT

You need to add a dynamic mechanism to handle upcoming years. Tresco suggested a good way but it is half done.

You need to handle both max YEAR as well as Today. The reason behind this is what if the data is having only data till 2016 and you are running the report in 2017 ?

Re: How do we get max year values

Tue, 07 Jun 2016 05:52:02 GMT

You want latest 3 months or maximum date?

Re: How do we get max year values

Kushal_Chawda — Tue, 07 Jun 2016 06:10:20 GMT

MaxYear:

LOAD Year(Max(asofdt)) as MaxYear

FROM Table;

let vMaxYear = peek('MaxYear',0,'MaxYear');

Data:

LOAD *

FROM table

where year(asofdt)='$(vMaxYear)'

Re: How do we get max year values

Tue, 07 Jun 2016 07:58:20 GMT

Thank you guys

Re: How do we get max year values

Tue, 07 Jun 2016 07:58:39 GMT

It's working....! Thanks you