topic Filtering zero values in QlikView

Filtering zero values

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

In the chart I have following expression:

Sum({$<DatCen={">=$(vStartDate) <=$(vEndDate)"}, [Entry Type]={1}>}-Quantity)

My goal is to filter data to show only zero values or values which are <=vInput.

Suppress zero values in Presentation tab is not an option in this case, My opinion is that I can solve this through calculated dimension I Was try with:

=If(Aggr(Rank(Sum({$<DatCen={">=$(vStartDate) <=$(vEndDate)"}, [Entry Type]={1}>}-Quantity)<=vInput), Sum({$<DatCen={">=$(vStartDate) <=$(vEndDate)"}, [Entry Type]={1}>}-Quantity))<=vInput, Sifra, Null())

but result is error. Any ideas?

TIA, Igor

Re: Filtering zero values

Kushal_Chawda — Fri, 29 Sep 2017 10:13:51 GMT

try below calculated dimension

aggr(if(Sum({$<DatCen={">=$(vStartDate) <=$(vEndDate)"}, [Entry Type]={1}>}-Quantity)<=$(vInput),

Sifra,null()),Sifra)

check suppress when value i NULL option on calculated dimension

Expression will be like below

Sum({$<DatCen={">=$(vStartDate) <=$(vEndDate)"}, [Entry Type]={1}>}-Quantity)

Re: Filtering zero values

Fri, 29 Sep 2017 11:32:19 GMT

Thx for your reply, but with yours calculated dimensions all records are shown as null()

Re: Filtering zero values

Kushal_Chawda — Fri, 29 Sep 2017 13:01:20 GMT

Make sure that vInput has numerical value. it will be helpful if you can share the sample to look at

Re: Filtering zero values

Fri, 29 Sep 2017 14:18:58 GMT

You are correct. Thank you very much. Now I will have peaceful weekend.