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

[sudeepkm]

These are the fields what I see in the qvd.

As per you Model head-fuel used-Vehicle type,Model name is the group.

Are you referring to FuelType as fuel used and i do not see a Vehicle type and the Model Name you mean Model Type ? Please clarify and what is the expression in your chart. is it count(ID) or something else.

[deepakqlikview_123]

Hi Sudeep ,

i am using,

count( if(IsCancelled = '0',ChassisNumber))

Thanks

[#4]

Hi,

Use the following as your dimension:

if(isnull(ModelHead), 'City 200 AF', Capitalize(ModelHead))

Regards

Rahul

[sudeepkm]

the field ChassisNumber and IsCancelled are not present in the QVD. it looks like you have other tables which are not provided here.

[sudeepkm]

try reduce load like 1000 records or so and you can also scramble the data and then you can share. it will be of small size. without looking at all the fields used in the chart it is difficult to suggest a solution.

[deepakqlikview_123]

Hi Sudeep,

ChassNumber is in my fact table.

That is diff table.

As size is too big I am not able to upload data.

thanks,

[deepakqlikview_123]

Hi Sudeep,

Please find attached Retail Qvd,

Thanks

[deepakqlikview_123]

Hello all issue has been resoled,

I have applied below formula

=if(isnull([Model Head]),'City 200AF',[Model Head]).

On dimension.

thanks