"Suppress when value if null" for expressions

[Anonymous]

Hi, all,

Now I am working to filter the data based on expression columns for nprinting.

In the qlikview table, we need to show all the data, and for nprinting report purpose, we need to select the revenue>=100.

After I use the variable  and expressions as below to make the expression column null:

=IF(($(vRev)=1 and SUM(HourRevenue)<100),NULL(),SUM(HourRevenue))

They are still in the table, I am wondering is there an option like "Suppress when value if null" for dimensions to hide the whole row when this expression column is "null"?

Thanks

[Anonymous · Accepted solution]

hi, all,

Thanks for all your answers.

As it is possible to suppress data based on Dimension column, it should also be possible to suppress data based on Expression columns.

Finally I used a dirty solution. But always welcome if there is anything better.

I modify to make other expression columns null if the column REVENUE is null. Then the rows for REVENUE can be filter out.

BTW, AGGR() is not the trick. And you can just use normal SUM(..), not AGGR(SUM(...),Dim)

[oboute]

Hello,

Thank's for the trick !

I was stuck like you and i did the same (others expressions = 0 when my expression =0).

Did you found something less dirty ?

[Anonymous]

Hi, Olivier,

Unfortunately, I did not find other solution.

Zhihong