topic Re: Load Max Month in Script in QlikView

Load Max Month in Script

dunnalahk123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a QVD where it will have all months but i always i want to take latest month data from that QVD.

Month Format : 201802

FROM

(qvd)

where Month=Max(Month);

i used above condition but it always fails, can some one guide me how can i give where clause condition.

Best Regards,

shiveshsingh — Mon, 19 Mar 2018 15:07:52 GMT

Try

Month=Date(Max(Month),'YYYYMM')

micheledenardi — Mon, 19 Mar 2018 15:09:40 GMT

The best way to do this is by using Max() function:

Load:

Max(Month) as Month

FROM (qvd);

ychaitanya — Mon, 19 Mar 2018 15:12:06 GMT

use as

Temp:

Load Month(Max(Date(Date#(Date_Field,'YYYYMM')))) as Max_Month_Date

Resident your_table_name;

1 way :

Load *

Resident Your_Table_name

where Exists (Month(Date_Field,Max_Month_Date);

Drop Table Temp;

2 way :

Load Month(Max(Date(Date#(Date_Field,'YYYYMM')))) as Max_Month_Date

Resident your_table_name;

Let vMaxMonth=Peek('Max_Month_Date',0,'Temp');

Load *

Resident Your_Table_name

where Month(Date_Field)='$(vMaxMonth)';

Thanks