How to put conditions on one field.

[#1]

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.

[petter]

You can do this:

Sum( {<wo_due_date={'$(=Now())'}>} Sales )

[#3]

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.

[ger_alegria · Accepted solution]

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()

[#5]

It Works, I will appreciate your help.

Regards.