Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

datalakeyu
Valued Contributor

How to hide 0 value in Qlik sense when using Set Analysis?

My table has two columns: myDate and myNumber.

I use myDate as dimension and myNumber as measure, and try to plot accumulation of myNumber.

I use the following Set Analysis to show default of myNumber on chart (bigger than 20) if I do not select a date range.

If(GetSelectedCount(myDate),

    RangeSum ( above ( Sum(myNumber) , 0 , RowNo() ) ) ,

    RangeSum ( above ( Sum({$< myNumber *= {">=20" } >} myNumber) , 0 , RowNo() ) )

  )

I also uncheck 'Show zero value' at Qlik sense.

However, there is still 0 value on the chart?

Any suggestion is appreciated!

hide 0 in set analysis.JPG

1 Solution

Accepted Solutions

Re: How to hide 0 value in Qlik sense when using Set Analysis?

When I open your qvf file I see this:

Capture.PNG

I am not seeing leading zero line chart. The reason could be that you are using an older version of Qlik Sense. I am using Qlik Sense 3.0. I think once you update to the recent version, you should be good to go

5 Replies
Not applicable

Re: How to hide 0 value in Qlik sense when using Set Analysis?

Are you able to post the sample app. You don't want to show 0, but do you still want to show those dates with no value or don't show those dates as well?

datalakeyu
Valued Contributor

Re: How to hide 0 value in Qlik sense when using Set Analysis?

Nhu, thanks for your help!

Please check the attached app.

I do not want to show 0; I do not want to show those dates with no value either.

Any suggestion is appreciated!

Re: How to hide 0 value in Qlik sense when using Set Analysis?

When I open your qvf file I see this:

Capture.PNG

I am not seeing leading zero line chart. The reason could be that you are using an older version of Qlik Sense. I am using Qlik Sense 3.0. I think once you update to the recent version, you should be good to go

Not applicable

Re: How to hide 0 value in Qlik sense when using Set Analysis?

Me too , I'm on v3 so i see the same as what Sunny sent

datalakeyu
Valued Contributor

Re: How to hide 0 value in Qlik sense when using Set Analysis?

Nhu and Sunny , thanks so much for your help!

I tried Qlik sense 3.0 and get the same plot without 0 value on the chart as you suggested.

Community Browser