Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Remove the zero value rows from Data

Hi.

There is a column called Closing Stock in attached table. I want to remove the rows where the Closing stock is 0. I don't have access to the script so changes will have to be made in the measure using set analysis. 

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Remove the zero value rows from Data

Hi Giselle,

You don't need set analysis for this.

Fill this in both your measures:

IF([Closing Stock] = 0,null(),[Closing Stock])

IF([Closing Stock] = 0,null(),[YourOtherMeasure])

Make sure that suppress zero values is on (See Add-on --> Data handling).

Jordy

Climber 

Work smarter, not harder

View solution in original post

5 Replies
Highlighted
Partner
Partner

Re: Remove the zero value rows from Data

Hi Giselle,

You don't need set analysis for this.

Fill this in both your measures:

IF([Closing Stock] = 0,null(),[Closing Stock])

IF([Closing Stock] = 0,null(),[YourOtherMeasure])

Make sure that suppress zero values is on (See Add-on --> Data handling).

Jordy

Climber 

Work smarter, not harder

View solution in original post

Highlighted
Contributor III
Contributor III

Re: Remove the zero value rows from Data

Thank you, this worked perfectly.

Highlighted
Contributor III
Contributor III

Re: Remove the zero value rows from Data

Hi,

as Jordy stated above, you don't need Set Analysis to achieve this.

However it could be useful to calculate something...  a KPI for example.
See below:

 

Calculate the sum of 'Current sell Price' excluding rows where Closing Stock is 0

Sum( {1 <[Closing Stock] =- {'0'}> } [Current Sell Price Incl])

 

HTH.
Ciao,
/Andrea

Highlighted
Partner
Partner

Re: Remove the zero value rows from Data

Hi Andrea,

That is correct, only your formula needs the '-' in front like this:

Sum( {1 <[Closing Stock] -= {'0'}> } [Current Sell Price Incl])

Jordy

Climber 

Work smarter, not harder
Contributor III
Contributor III

Re: Remove the zero value rows from Data

Yes Jordy,  you're right!

I meant -=

but if you try =- works too (but better to avoid confusion...)

Here an interesting post regarding this topic:
https://community.qlik.com/t5/New-to-QlikView/set-analysis-difference-between-and-operations/m-p/978...

 

Ciao,
/Andrea