Hide records with KPI = 0

[jorditorras]

Dear Gurús, 

I'm developing an App in QlikSense where I've created a straight table with "Document number" as Dimensions and KPI1, KPI2 and KPI3. 

I'd like to hide all the "Document numbers" with the KPI1 = 0 (even when KPI2 or KPI3 has some values). 

Any idea how can I do this??

Thanks!!

[IamAlbinAntony]

Try this in Dimension instead of "Document number" then hide null value,

if(aggr(sum(KPI1),[Document number] ,KPI1)>0,[Document number]  ,null())

[jorditorras]

Many thanks for your reply, but it's not working... There's a message error of "Invalid Dimension"...

[agigliotti]

try replacing your dimension with:

=aggr( if( sum(KPI1) <> 0, [Document number], null() ), [Document number] )

and untick "Include null values".

[jorditorras]

Thanks for your reply!

If I try this I still see the documents with KPI1 <>0 and the ones with KPI1=0...

[agigliotti · Accepted solution]

try this:

=aggr( if( sum(KPI1) > 0, [Document number], null() ), [Document number] )

and remember to  untick "Include null values".

what you get?

it the above doesn't works try this one:
=aggr( if( sum(alt(KPI1,0)) <> 0, [Document number], null() ), [Document number] )