Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 ;
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 ;
Hi Anil, for some reason it didn't work. It's still returning 0 as the value.
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:
https://community.qlik.com/t5/Qlik-Design-Blog/Why-don-t-my-dates-work/ba-p/1465849
https://community.qlik.com/t5/Qlik-Design-Blog/The-Date-Function/ba-p/1463157
I think those two should hopefully help you move things forward.
Regards,
Brett