This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I am very new in Qlikview, I would like some assistance calculate number of days between 2 dates and exclude nulls in that expression.
I did this on my expression in straight table with Supplier as my dimension
date#(GirGrvOrderDate-GirPrefDelDate) however its diving nulls on some values.. how can I remove nulls on expression
my goal is to trace how many days was my supplier late for delivery
I tried that it displays null on my calculated expression
use calculated dimension in place of Supplier
if (GirPrefDelDate-GirGrvOrderDate >1,Supplier)
it will show only suppliers who have value in day columns
When I use if (GirPrefDelDate-GirGrvOrderDate >1,Supplier) it returns no values on my straight table which is wrong however I tried
if(GirPrefDelDate-GirGrvOrderDate >'',Supplier) then it worked, does ' ' represent null in Qlikview?
Use calculated dimension:
if (not isnull(GirPrefDelDate) and not isnull(GirGrvOrderDate) ,Supplier)
No, '' does not mean NULL. It means an empty string. Your comparison does not make a numeric comparison, but instead a string comparison.
The problem you have in your first expression, is that you have naked field references (no aggregation function), which will create problems. You could try
Concat(If(GirPrefDelDate-GirGrvOrderDate >1,Supplier), ',')
See more on Use Aggregation Functions!
if (not isnull(GirPrefDelDate) and not isnull(GirGrvOrderDate) ,Supplier) works perfectly.
Try this expression.
These two expression worked for number of days between 2 dates 🙂 🙂
Thank you so much for your help guys..
Please mark the answer as correct to close this thread.
How do i do that... . i have looking for the icon i cannot see it