Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Morning everybody.
I'm trying to put a condition in one field in qlik sense, but it does not work.
The condition will be the quantity open on the currect day.
I'm placing this expresión : wo_due_date = now()
Where wo_due_date is the fiel on my table and now (0) is today.
Any clue on how to place the expression?
Maybe I'm using an incorrect expression.
Thanks in advance.
Regards.
Try with:
Sum( {<wo_due_date={'$(=Today())'}>} wo_qty_req - wo_qty_comp)
If wo_due_date is only a date and not a date with time try with Today()
You can do this:
Sum( {<wo_due_date={'$(=Now())'}>} Sales )
Good Morning.
Maybe I'm doing something wrong.
This is my expresión : Sum( {<wo_due_date={'$(=Now())'}>} wo_qty_req - wo_qty_comp)
Where wo_due_date is today and wo_qty req is the quantity requested minus quantity completed.
I'm putting this exprssion into Calculation Condition and It does not work.
Try with:
Sum( {<wo_due_date={'$(=Today())'}>} wo_qty_req - wo_qty_comp)
If wo_due_date is only a date and not a date with time try with Today()
It Works, I will appreciate your help.
Regards.