Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi @Rothschild ,
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
Hello @Rothschild ,
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
Hi @rushikale0106 ,
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?
Hi @Rothschild ,
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