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

Announcements
Discover how organizations are unlocking new revenue streams: Watch 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