Remove the zero value rows from Data

[Giselle100]

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. 

[JordyWegman · Accepted solution]

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 

[Giselle100]

Thank you, this worked perfectly.

[docpuddu]

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]

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 

[docpuddu]

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