topic Re: Display specific values with 0 values in QlikView

Display specific values with 0 values

KaisGarci — Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone,

I am trying to create a pivot table. there is a row that I want to display only a specific value and its sales. I am doing this ' =if(SEGMENT='TRE',SEGMENT) ' in Add calculated dimesion and I am checking supress when value is null. The problem is that the 0 values are not displayed while I want to display them. And when I don't check Supress when value is null it show me the '-' as shown in the picture.

Can anyone help me with this please ?

Thank you

Re: Display specific values with 0 values

rushikale0106 — Wed, 19 Aug 2020 11:22:01 GMT

Hello @KaisGarci ,

The following expression might help you with the Suppress Null value which is showing '-' if its null.

=if(isnull(column_name), 'Other', column_name_or_anything_you_want_to_display)

It will solve your query with suppressing null values with a different values.

Let me know if I am misunderstanding your query and give some more details on your question.

And if it solves your query, mark the answer as Solution which might help others.

Regards,

Rushi

Re: Display specific values with 0 values

KaisGarci — Wed, 19 Aug 2020 11:35:34 GMT

Hello @rushikale0106 ,

Thanks for responding.

Yes it helped me to avoid the '-' but the table still don't display '0' values.

Re: Display specific values with 0 values

rushikale0106 — Wed, 19 Aug 2020 11:48:28 GMT

Hi @KaisGarci ,

Glad to help.

Try to uncheck the boxes given in the image. It might be restricting your values to display 0 values.

I tried it in my system, it worked with it.

If it does not solve your query, let me know the question in more detail.

Thanks & Regards,

Rushi

Re: Display specific values with 0 values

KaisGarci — Fri, 21 Aug 2020 09:11:13 GMT

Yes, it worked @rushikale0106

Thank you for your help, I really appreciate that.