topic Re: Hide records with KPI = 0 in App Development

Hide records with KPI = 0

jorditorras — Mon, 20 Dec 2021 21:08:46 GMT

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 — Wed, 06 May 2020 09:22:19 GMT

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

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

jorditorras — Wed, 06 May 2020 09:47:24 GMT

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

agigliotti — Wed, 06 May 2020 09:48:46 GMT

try replacing your dimension with:

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

and untick "Include null values".

jorditorras — Wed, 06 May 2020 10:05:54 GMT

Thanks for your reply!

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

agigliotti — Wed, 06 May 2020 10:23:29 GMT

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] )