How to hide row when Total debt amount = 0 ?

[paulyeo11]

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]

my QVW

[MindaugasBacius]

Try using this script:

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

It seems to work fine:

[vinieme12]

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]

Hi Paul,

see attached file.

hope this helps

[paulyeo11]

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 · Accepted solution]

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

hope this helps

[paulyeo11]

Hi Frank

Thank you very much it work fine.

Paul