Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

How to put conditions on one field.

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.

1 Solution

Accepted Solutions
ger_alegria
Contributor

Re: How to put conditions on one field.

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

4 Replies
MVP
MVP

Re: How to put conditions on one field.

You can do this:

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

Not applicable

Re: How to put conditions on one field.

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
Contributor

Re: How to put conditions on one field.

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

Not applicable

Re: How to put conditions on one field.

It Works, I will appreciate your help.

Regards.