Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Null Symbol in barchart - qliksense

Hi All,

I create barchart that include 1 dimension and 1 measure.

In the barchart I get null values in the dimension but only when I add the measure that arrived from other table (there is no null values in the dimension itself ).

I want to change the null values in the dimension to 'N/A' , but when I add the following calculation in the dimension it  doesn't work because there is null data in the dim just when I add the measure :

if( IsNull(Region)=1,'N/A',Region)

I see there is "Null symbol" option in vizlib table and its work fine but I need to display the data as barchart\combochart and I don't see such an option there..

Any advise?

Thanks!

0 Replies