Skip to main content
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

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