Discussion Board for collaboration on QlikView Scripting.
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.
Go to Solution.
Not sure if i met your requirement but perhaps like attached sample
hope this helps
Try using this script:
If([Total Debt] = 0, 0, YOUR_EXPRESSION)
It seems to work fine:
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
see attached file.
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.
Thank you very much it work fine.