topic Re: Setting null symbol on one Dimension in QlikView

Setting null symbol on one Dimension

Anonymous — Tue, 21 Nov 2017 03:06:55 GMT

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 — Tue, 21 Nov 2017 04:43:43 GMT

Create Calculated Dimension for that Car

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

pradosh_thakur — Tue, 21 Nov 2017 06:53:44 GMT

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

Anonymous — Tue, 21 Nov 2017 09:48:59 GMT

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 — Tue, 21 Nov 2017 10:16:55 GMT

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

regards

Pradosh