Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Have done it in two way. use main or main2 in the script and the corresponding table as per your requirement.
regards
Pradosh
Create Calculated Dimension for that Car
If(IsNull(Cat), 'other', Cat)
=if( len(trim(Cat))=0,'Other',Cat)
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
Have done it in two way. use main or main2 in the script and the corresponding table as per your requirement.
regards
Pradosh