# New to QlikView

Discussion board where members can get started with QlikView. Not applicable

## Filtering zero values

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

1 Solution

Accepted Solutions MVP

## Re: Filtering zero values

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

4 Replies MVP

## Re: Filtering zero values

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) Not applicable

## Re: Filtering zero values

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

## Re: Filtering zero values

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

## Re: Filtering zero values

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