Setting null symbol on one Dimension

[Anonymous]

Dear all,

I would like to set the null symbol on one dimension.

However, when i set the null symbol, it changes in all dimension,

Please see with the attachment.

Is there any way to only change the null value in "Cat" to other?

Thanks a lot.

Best Regards,

Louis

[Anil_Babu_Samineni]

Create Calculated Dimension for that Car

If(IsNull(Cat), 'other', Cat)

[pradosh_thakur]

=if( len(trim(Cat))=0,'Other',Cat)

[Anonymous]

Hi All,

Thank you for reply.

Both of your answer is able to fix the issue if there is only one table.

but I found that there will be some different if there is an association.

I have updated the qvw file for testing.

Please help.

Thanks a lot.

Best Regards,

Louis

[pradosh_thakur · Accepted solution]

Have done it in two way. use main or main2 in the script and the corresponding table as per your requirement.

regards

Pradosh