topic Qlikview Date scripting in QlikView

Qlikview Date scripting

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

Hi Need help with the following script, does the format as seem right as far as the if statement.

I am trying to find the value of the new products based on the following equation.

Load

If ( Invoice_Date >= prod_LaunchDate, Value,0) as New_Value ;

SQL select *

From table;

Best Regards

Anil_Babu_Samineni — Tue, 26 Nov 2019 14:20:00 GMT

That is right, May be few cases need to be written with number format as

If ( Num(Invoice_Date) >= Num(prod_LaunchDate), Value,0) as New_Value ;

Hum1 — Tue, 26 Nov 2019 14:58:21 GMT

Hi Anil, for some reason it didn't work. It's still returning 0 as the value.

Brett_Bleess — Mon, 09 Dec 2019 22:07:37 GMT

My suspicion would be the date in the backend is not being recognized as a date by QlikView...

Here are some Design Blog posts that may be helpful:

I think those two should hopefully help you move things forward.

Regards,
Brett