topic Re: How to hide row when Total debt amount = 0 ? in QlikView

How to hide row when Total debt amount = 0 ?

paulyeo11 — Sun, 27 Nov 2016 13:45:14 GMT

Hi All

I have Table 1 , i like to hide those row , when column = Total Debt amount equal zero. Hope some one can advise how to do it.

i have already set the diamension all field to hide row when null value.

Paul .

paulyeo11 — Sun, 27 Nov 2016 13:47:03 GMT

my QVW

MindaugasBacius — Sun, 27 Nov 2016 14:30:29 GMT

Try using this script:

If([Total Debt] = 0, 0, YOUR_EXPRESSION)

It seems to work fine:

vinieme12 — Sun, 27 Nov 2016 14:32:20 GMT

haven't seen the app

but add a calculated dimension something as below

AGGR(if( ExpressionforDEBT > 0 , Field ), Field)

Then check Supress when value is null on this dimension

Frank_Hartmann — Sun, 27 Nov 2016 14:34:14 GMT

Hi Paul,

see attached file.

hope this helps

paulyeo11 — Sun, 27 Nov 2016 14:45:23 GMT

Hi Frank

Thank you very much for your help,

Ref to your Table 1 it only display 3 Row.

Kindly Ref to Table 2 , Top 5 Row have value. Can you advise me how to make Table 1 display those 5 Row.

Paul

Frank_Hartmann — Sun, 27 Nov 2016 15:27:21 GMT

Not sure if i met your requirement but perhaps like attached sample

hope this helps

paulyeo11 — Sun, 27 Nov 2016 15:31:21 GMT

Hi Frank

Thank you very much it work fine.

Paul