Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show values with codition is null

I want to display values with condition column 'Hors Vente' = - (Null)

Thx in advance

15 Replies
Not applicable
Author

exactly...


thx in advance

Kushal_Chawda

Create Calculated dimension.

if( Isnull([Hors Vente]) or len(trim([Hors Vente]))<=0, SellEndDateProduct,null())

Check Suppress when value is null for this calculated dimension

Not applicable
Author

Does not work. I want to show only values (NameProduct) with condition column 'Hors vente' = Null or -

Kushal_Chawda

Can you post screenshot of your expression you have written? or it will be better if you can share sample application

sunny_talwar

May be this:

=If(Len(Trim([Hors Vente])) = 0, NameProduct) and Check 'Suppress When Value is Null' on the Dimension tab.

The above calculated dimension expression should replace NameProduct dimension.

I hope this is what you are looking to get.

Best,

Sunny

Not applicable
Author

Thx, but does not work

Stanley