Show Dimension with NULL value in Bar Chart

[Anonymous]

Hi Folks,

I have a Bar Chart, Dimension MCJahrWoche and would like to show all Weeks in the Bar Chart, also those with no values.

Thereafter I want to calculate GetPossibleCount(MCJahrWoche) / All Weeks (including those with no values).

I tried some things, however, they did not work so far.

(Week 2017/02 to show with no bar,

calculation 6/7 = 0,857) (6 I get with GetPossibleCount(MC...), but how do I get the seventh week into it?)

Thank you so much in advance!

Wolfgang

[ramasaisaksoft]

For Dimension you need to un check the  option Suppress Null Values.

[Anonymous]

Hi Rama,

I un checked NULL-Werte weglassen (suppress) in Dimension as well as in Presentation.

Unfortunately this does not show up Week 2017/02

Wolfgang

[avinashelite]

Try this

Dimension : show all values

Presentation : un -check suppress the Zero values ...

if its still did not resolve the issue , share the app

[#5]

Do you get the same if you unchecks suppress zero-values in the presentation tab?

[Anonymous]

Dimension: show all values shows indeed all values, beside a 7-week-selection also all weeks of 5 years.

Wolfgang

[Anonymous]

I also do not get Week 2017/02 when suppress Null-values is unchecked in Presentation

[avinashelite]

Oh ok ..I taught you have only the limited values...share your app , I think we need to twik the expression s a bit

[beck_bakytbek · Accepted solution]

Hi Wolfgang,

look at this: https://www.youtube.com/watch?v=ARTnBy5vc6g

i hope that resolves your issue

beck

[sureshsindhigi]

Hi Wolf,

Hope you're doing great !!

Could you please refer the attached copy of QVW, excel and image screen, all you need to do in the presentation tab uncheck "Suppress Zero values" after you can see null values under weeks if you don't have any values the same.

Hope this is works for your requirement & confirm back is this fine.

Regards,

Suresh Sindhigi.