Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
SatyaPaleti
Creator III
Creator III

How to replace null's in dimension with a string in Line chart

Hi Everyone,

How to replace null values in a line chart dimension with a string 'No Branch Available'. Here is the screenshot for reference

SatyaPaleti_0-1624861882550.png

 

I am having a dimensions like Month, State and Measures count(Suppliers) in a line chart. There is a filter pane 'BRANCH'. in Branch if we select Warehouse 15 data will become null because no data for it. so in Dimension it show '-' we have to replace '-' with 'No Branch'. Can someone help on this

Here is the attached files for sample data and sample qvf 

 

Thanks,

Satya

5 Replies
Ponkaviyarasu
Partner - Contributor III
Partner - Contributor III

Hi Satya,

Use this expression:

For Month & State respectively.

=if(isnull(Month)=-1,'No Branch Available',Month)

=if(isnull(State)=-1,'No Branch Available',State)

Quy_Nguyen
Specialist
Specialist

Hi,

You could try this expression for State Dimension

=Aggr( If( Len(Trim(State))=0, 'No Branch', State), State )

 

SatyaPaleti
Creator III
Creator III
Author

Hi Partner,

 

Thank you so much for your response but still I am getting same error 😣

SatyaPaleti
Creator III
Creator III
Author

Hi Quy,

 

Thank you so much for your response but still I am getting same error 

Quy_Nguyen
Specialist
Specialist

So strange! I applied the solution from Ponkaviyarasu. It' s ok on my side.

Quy_Nguyen_0-1624891604154.png

Attached qvf