topic Re: Show excluded value in line chart dim in QlikView

Show excluded value in line chart dim

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

Hi,

I created a line chart with field 'Year' in Dimension, and Sum(Sales) as Experssion.

I want to see also exscluded years with zero value in Experssion.

How can I do that?

Thanks!!

I want to see 2014 also.

rushikale0106 — Mon, 21 Sep 2020 10:59:56 GMT

To solve your query, go to Chart properties of your Line Chart.

There go to the Dimensions tab and Uncheck the "Suppress When Value Is Null" option. Also, recheck on the Presentation tab for Suppress Zero-Values.

This must solve your query. Let me know if you face anything else with this.

Regards,

Rushika

Rothschild — Mon, 21 Sep 2020 11:38:00 GMT

Thank you for responding, but uncheck suppress null connot help here.

My main key in the QV model is Entity&YYYYMM.

I don't have record with 2014MM with null fields - I don't have a record to this entity in 2014 at all.

Do you undrstand the differance?

rushikale0106 — Mon, 21 Sep 2020 13:02:05 GMT

Yes. I guess I understand your question. You don't have any value with 2014 field.

Try to use this equation with your dimension where the no value is available as Null.

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

This might solve your problem. Let me know if it's still not working.

Regards,

Rushika