topic Re: Hide rows in straight table in QlikView

Hide rows in straight table

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I want to hide these rows that contain empty cells in accuracy column.

Any ideas, please?

I really need this work correctly to follow my analysis.

Best regards,

Alâa Eddine.

Re: Hide rows in straight table

kevinalvino — Mon, 25 Jun 2018 10:12:35 GMT

Hi Alaa,

Maybe you can use View Condition for Experssion in Straight Table?

Use the View Condition to all expression except Sub.Agg Brand Acc.. that if the Sub/agg brand acc.. is NULL , then dont show it..... should be the formula of calculating the Sub/Agg Brand Acc... in a IF formula and NULL Condition.

Hope it helps,

Best Regards,

Kevin

Re: Hide rows in straight table

Peter_Cammaert — Mon, 25 Jun 2018 10:41:29 GMT

Dimension columns have this nice option to "Suppress when Value is Null", and expressions have this feature built-in. Unfortunately, for rows to be suppressed based on the outcome of expressions, ALL expression results have to be either 0 or NULL. As long as a single expression is producing reasonable values, the row will show.

Luckily, there is a trick available that lets you suppress multiple-expression rows based on the value of only one or a few of those expression columns. Since you can refer to another expression result by simply using the column label as if it were a field name, you can write something like this for any of the other four expressions:

IF ([Sub/Agg Brand Acc...] <> 0, ExpressionForOtherColumn)

Make sure that the label between square brackets is complete, as your screenshot doesn't show the entire label text.

Re: Hide rows in straight table

pwagner — Mon, 28 Oct 2019 12:21:35 GMT

Hello @Peter_Cammaert

Perfect, thank you.