Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

straight table expression query

Hello All,

I have one more query

I have been calculating the the difference between two dates in the straight table.now i want to only show values which are in negative and show 0 where the value is positive.

Please help me with this.not sure how to do this.

    

order idorder_dateorder end dateshipment datedelivery date(orderdate - shipment date)
1 -1
2 -2
3 2
4 3

Thanks & Regards,

Jaya

1 Solution

Accepted Solutions

Re: straight table expression query

May be like this:

If((orderdate - shipment date) < 0, (orderdate - shipment date), 0)

and on the presentation tab, uncheck the option of Suppress When Zero.

8 Replies

Re: straight table expression query

May be like this:

If((orderdate - shipment date) < 0, (orderdate - shipment date), 0)

and on the presentation tab, uncheck the option of Suppress When Zero.

MVP
MVP

Re: straight table expression query

=RangeMin(orderdate - shipment date, 0)

This will replace positive results with zero.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Re: straight table expression query

Thanks a lot

Community Manager
Community Manager

Re: straight table expression query

Hi Jaya,

If your issue is resolved, please take a moment to Mark Replies as Correct or Helpful.

Thank you,

Qlik Community Team

Not applicable

Re: straight table expression query

Thanks Sunny

oknotsen
Honored Contributor III

Re: straight table expression query

If your question is now answered, please flag the Correct Answer.

If not, please make clear what part of your question you still need help with .

May you live in interesting times!
Not applicable

Re: straight table expression query

Hello Onno,

I could not find the option to do that.

Please let me know where i can do that from.

Regards,

jaya

oknotsen
Honored Contributor III

Re: straight table expression query

See attached screenshot.

May you live in interesting times!
Community Browser