Discussion Board for collaboration on QlikView Scripting.
I have a client who sometimes register the wrong amounts and goes in and corrects it to a 0. The issue is that I am using min date and because there is a 0 the date that is connected to that 0 value becomes the lowest date, not the actual real first payment.
Is there any way I can in my script create an IF statement or there is a function to turn something into a NULL so that it get registered as a "nothing"?
All numeric values other than 0 are evaluated as true, so all of them will be loaded, all others (0, text or null) will be loaded as null.
hope this helps
Something like below, I just used Marco code and applied here:
If(Daily_Date,Daily_Date) as Daily_Date,
LOAD * INLINE [
Hope this helps...