topic Re: Display Only Negative values in QlikView

Display Only Negative values

Anonymous — Tue, 21 Nov 2017 14:12:46 GMT

hello Guys,

Could you please help me with the following questions :-

I have a field with both positive and negative values.

I want to display all negative values in the Data Sheet .

Something like this as shown below :-

Thanks in Advance,

Ravi

sunny_talwar — Tue, 21 Nov 2017 14:14:42 GMT

May be like this,

RangeMin(ExpressionOrFieldName, 0)

Anil_Babu_Samineni — Tue, 21 Nov 2017 14:15:11 GMT

May be this?

If(Sum(Interval) <0, Interval)

Sum({<Interval = {'<0'}>} Interval)

Anonymous — Tue, 21 Nov 2017 14:30:12 GMT

Thanks for your reply Guys,

I donnt need to do any sum or any aggregation function .

I just need create a new column in data sheet with only negative values (without null values)

I am using this as dimension expression which I need for data sheet

If (Interval<0,(Interval)) this expression works for me but shows null values too.

how to get rid of null values using above expression .

Thanks,

ravi

sunny_talwar — Tue, 21 Nov 2017 14:33:11 GMT

May be check 'Suppress When Value Is Null' on the dimension tab of chart properties

Anonymous — Tue, 21 Nov 2017 15:15:59 GMT

Ok ! Thanks will try !