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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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