topic Re: straight table expression query in QlikView

straight table expression query

Wed, 25 May 2016 10:48:58 GMT

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 id	order_date	order end date	shipment date	delivery date	(orderdate - shipment date)
1					-1
2					-2
3					2
4					3

Thanks & Regards,

Jaya

Re: straight table expression query

sunny_talwar — Wed, 25 May 2016 11:03:54 GMT

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.

Re: straight table expression query

jonathandienst — Wed, 25 May 2016 11:04:33 GMT

=RangeMin(orderdate - shipment date, 0)

This will replace positive results with zero.

Re: straight table expression query

Wed, 25 May 2016 17:42:08 GMT

Thanks a lot

Re: straight table expression query

Anonymous — Wed, 25 May 2016 18:15:45 GMT

Hi Jaya,

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

Thank you,

Qlik Community Team

Re: straight table expression query

Thu, 26 May 2016 06:06:02 GMT

Thanks Sunny

Re: straight table expression query

oknotsen — Thu, 26 May 2016 07:22:10 GMT

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 .

Re: straight table expression query

Thu, 26 May 2016 07:36:20 GMT

Hello Onno,

I could not find the option to do that.

Please let me know where i can do that from.

Regards,

jaya

Re: straight table expression query

oknotsen — Thu, 26 May 2016 07:57:02 GMT

See attached screenshot.