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

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
suvechha_b
Creator III
Creator III

how to write show blank in dimension if other condition is null

How can I write the set analysis in dimension.

See the below screenshot

Capture.PNG

How can I show [Division Code] and [Division Name] as blank when [Customer Code Name] is blank in qlikview level.

All of them are dimension in chart.

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

You can't use set analysis for this. Try calculated dimensions:

=if(Len(Trim([Customer Code Name])<>0,[Division Code])

=if(Len(Trim([Customer Code Name])<>0,[Division Name])


talk is cheap, supply exceeds demand