topic Date field in QlikView

Date field

cksuperlatif — Mon, 14 Dec 2015 17:14:52 GMT

Hi,

I loaded many table with many date field, and I want only data where Year(Date_Field) >= Year(Today()) - 2.

for example:

Year(Date_Paiemant) >= Year(Today()) - 2

Year(Date_Produit) >= Year(Today()) - 2

Year(Date_Commande) >= Year(Today()) - 2

Year(Date_Facture) >= Year(Today()) - 2

and many other in few table.

So, can I have something like that, perhaps at the beginning of my script

Year(Date_*) >= Year(Today()) - 2

sinanozdemir — Mon, 14 Dec 2015 17:18:51 GMT

You can use Where clause in the load script:

LOAD

FROM/Resident Your_data_source_name

Where Year(Date_Field) >= Year(Today()) - 2;

Hope this helps.

JonnyPoole — Mon, 14 Dec 2015 18:17:21 GMT

If you are doing this multiple tables, you should set a variable:

let vFilterYear=Year(Today()) -2;

LOAD

FROM/Resident Your_data_source_name

Where Year(Date_Field1) >= $(vFilterYear);

LOAD

FROM/Resident Your_data_source_name

Where Year(Date_Field2) >= $(vFilterYear);

etc...

cksuperlatif — Tue, 15 Dec 2015 08:45:32 GMT

Thank jpe , I will try this

cksuperlatif — Tue, 15 Dec 2015 08:46:21 GMT

Thank jpe for your attention