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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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

Labels (1)
15 Replies
Not applicable
Author

exactly...


thx in advance

Kushal_Chawda
MVP
MVP

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
MVP
MVP

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

sunny_talwar
MVP
MVP

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