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

Excluding dimensons that are not equal to null


I have a dimension where some of the records are null and some contain a 4 digit code. I only want to include the null records but when I try to create a calculated dimension I just get blank records in the value fields

I've attached my QVD and its the table that is showing trading partner is where I'm looking to only include the null value records

12 Replies
Gabriel
Partner - Specialist III
Partner - Specialist III

Hi,

That's just an idea of what the Set Analysis should look like.

Try this

TEXT({<Flag_TradingPartner ={1}>} Flag_TradingPartner)

Not applicable
Author

Do I create this as a dimension ?

Gabriel
Partner - Specialist III
Partner - Specialist III

Yes