Condition

[deepakqlikview_123]

Hi All,

Please find attached screenshot and QVD .

I am using condition only

  capitalize( ModelHead) as [Model Head], 

I want to replace - by City 200 AF.

Please suggest

Thanks

[alexandros17]

Generally if you see - the reason is that there are null values so you must check data relation.

Attach your document if you can and I'll take a look

[sudeepkm]

you can use isnull() function or something like below.

if (len(ModelHead)>0,capitalize( ModelHead),'City 200 AF') as [Model Head]

[Anonymous · Accepted solution]

Try something like

     if ( isnull ( [ModelHead] ) , 'City 200 AF' , [ModelHead] )

[Anonymous]

...... or on the Presentation tab of your chart for the Null Symbol replace the - with what you want.

[deepakqlikview_123]

Can you please give me screenshot for the same for making changes.

thanks,

Deepak

[Anonymous]

I am sure you can find the Presentation tab of your chart without a screen shot, Null Symbol is then in the bottom left hand corner.

[deepakqlikview_123]

HiBill,

Still i am not able to find it, please suggest.

Thanks

[sudeepkm]

can you please share the qvw you are using or the chart expression and dimensions as per your screenshot.

As I could not find any null entries when I loaded data from your QVD for ModelHead.

In your screenshot the Model Head looks like a Drill Group. Can you please give some more detail.

[deepakqlikview_123]

Hi sudeep,

As application size is too huge i am not able to share

QVW file with u.I am using drill grp in following hierarchy,

Model head-fuel used-Vehicle type,Model name.

Thanks