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

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

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

Thank you, this worked perfectly.

Highlighted
Contributor III
Contributor III

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

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
Highlighted
Contributor III
Contributor III

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