topic Re: Exclude negative and positive values from expression in QlikView

Exclude negative and positive values from expression

darkshadow91223 — Thu, 04 Jan 2018 18:13:08 GMT

Hi,

I have the expression to calculate difference.

But i only want to show negative difference (Value) also excluding positives values in the calculation. and then vice versa (show +ve, exclude -ve)

Num(1 - Sum({<TimeStamp={'Old'}>}Amount) / Sum({<TimeStamp={'New'}>}Amount), '#,###.#0%')

How do i do this?

Any help please?

Num(1 - (Sum({<TimeStamp={'Old'}>}Amount) / Sum({<TimeStamp={'New'}>}Amount))<0, '#,###.#0%')

Thank you!

sunny_talwar — Thu, 04 Jan 2018 18:44:00 GMT

May be this

Positive Values

Num(RangeMax(1 - Sum({<TimeStamp={'Old'}>}Amount) / Sum({<TimeStamp={'New'}>}Amount), 0), '#,###.#0%')

Negative Values

Num(RangeMin(1 - Sum({<TimeStamp={'Old'}>}Amount) / Sum({<TimeStamp={'New'}>}Amount), 0), '#,###.#0%')

darkshadow91223 — Fri, 05 Jan 2018 16:44:48 GMT

Thank you! it works!!

sunny_talwar — Fri, 05 Jan 2018 16:57:12 GMT

Awesome, please close the thread by marking the correct and helpful responses.

Best,

Sunny