Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

poluvidyasagar
Contributor

Hide rows based on null or zero values in the measure

Hi, 

I am trying to hide rows where measure values are zero or null.  This works well if i have only one measure. 

How do i make it work when i have more than one measure ?

I have attached a test case qvw file for reference.

I have want to hide rows where check column in null

Capture.PNG

Thanks,

Vidya

1 Solution

Accepted Solutions

Re: Hide rows based on null or zero values in the measure

Hi, If a cell has a value for a row that row will be shown.

You can check each dimension like "=If(not IsNull([Check]), count(Package))"

Or do a calculated dimension like "=aggr(if(Count([Order Number])+Count(Package)<2, [Part Number]), [Part Number])"

1 Reply

Re: Hide rows based on null or zero values in the measure

Hi, If a cell has a value for a row that row will be shown.

You can check each dimension like "=If(not IsNull([Check]), count(Package))"

Or do a calculated dimension like "=aggr(if(Count([Order Number])+Count(Package)<2, [Part Number]), [Part Number])"