Solved: "Suppress when value if null" for expressions - Qlik Community

Anonymous · ‎2014-09-12

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 · ‎2014-09-12

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)

View solution in original post

ecolomer · ‎2014-09-12

Yes, you can put in a dimension the expresion if(IsNUll( xxx), ....) and select the option supres if is null

PrashantSangle · ‎2014-09-12

Hi,

You can use

Isnull(fieldName)

or

len(fieldName)>0

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Anonymous · ‎2014-09-12

Hi, Enrique,

Sorry for confusing you. But I think you do not understand my question well.

I do not need to hide the row based on the "Dimensions", I need to hide the row based on "Expressions". So the "Suppress when value if null" in "Dimensions" tab dose not work.

PrashantSangle · ‎2014-09-12

Hi,

In Presentation tab you have Supress missing and Spress Zero Values.

Try it.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Anonymous · ‎2014-09-12

Hi, Max,

Sorry for confusing you as well. I do not need to hide the data base on "fieldName". As it is a column from "Expression" tab. It can not be used in the "Calculated Dimension", and the "Enable Conditional" in Dimensions tab.

PrashantSangle · ‎2014-09-12

Hi,

If you have only one expression then

In presentation tab you have Supress missing and Supress Zero Values

They work as per your requirement.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

ecolomer · ‎2014-09-12

But you need to supres the column?

Or supress the row when the value of column is null?

In this last case you put in the dimension the expresion:

if(IsNull(expresion, Null(), Dimension)

and select the option to supress if is null

Anonymous · ‎2014-09-12

Hi, Enrique,

I need to suppress the whole row.

I tired to use expression as below in Calculated Dimension:

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

But it dose not work.

Am I doing somthing wrong?

Anonymous · ‎2014-09-12

Hi, Max,

I have more than one expression.

Hi, Piet,

It is strange that the last reply from Piet is gone.

This solution works when there is one expression column. But dose not work for multiple expression columns.

See the example I reused from Piet. I would like to select the table when REVENUE>100, when CONV column still have data.