Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
paulyeo11
Valued Contributor II

How to hide row when Total debt amount = 0 ?

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 .

1 Solution

Accepted Solutions
Frank_Hartmann
Honored Contributor

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

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

hope this helps

7 Replies
paulyeo11
Valued Contributor II

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

my QVW

MindaugasBacius
Valued Contributor II

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

Try using this script:

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

It seems to work fine:

Screenshot_1.jpg

vinieme12
Esteemed Contributor II

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

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
Honored Contributor

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

Hi Paul,

see attached file.

hope this helps

paulyeo11
Valued Contributor II

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

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
Honored Contributor

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

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

hope this helps

paulyeo11
Valued Contributor II

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

Hi Frank

Thank you very much it work fine.

Paul

Community Browser