Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Giselle100
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
JordyWegman
Partner - Master
Partner - Master

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
JordyWegman
Partner - Master
Partner - Master

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
Giselle100
Contributor III
Contributor III
Author

Thank you, this worked perfectly.

docpuddu
Creator
Creator

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

JordyWegman
Partner - Master
Partner - Master

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
docpuddu
Creator
Creator

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