Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. 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