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

[SatyaPaleti]

Hi Everyone,

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

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

[Ponkaviyarasu]

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]

Hi,

You could try this expression for State Dimension

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

[SatyaPaleti]

Hi Partner,

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

[SatyaPaleti]

Hi Quy,

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

[Quy_Nguyen]

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

Attached qvf