topic Re: Show Dimension with NULL value in Bar Chart in QlikView

Show Dimension with NULL value in Bar Chart

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

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

Re: Show Dimension with NULL value in Bar Chart

ramasaisaksoft — Mon, 27 Feb 2017 14:00:52 GMT

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

Re: Show Dimension with NULL value in Bar Chart

Anonymous — Mon, 27 Feb 2017 14:12:36 GMT

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

Re: Show Dimension with NULL value in Bar Chart

avinashelite — Mon, 27 Feb 2017 14:17:41 GMT

Try this

Dimension : show all values

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

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

Re: Show Dimension with NULL value in Bar Chart

Mon, 27 Feb 2017 14:19:12 GMT

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

Re: Show Dimension with NULL value in Bar Chart

Anonymous — Mon, 27 Feb 2017 14:20:50 GMT

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

Wolfgang

Re: Show Dimension with NULL value in Bar Chart

Anonymous — Mon, 27 Feb 2017 14:22:35 GMT

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

Re: Show Dimension with NULL value in Bar Chart

avinashelite — Mon, 27 Feb 2017 14:22:57 GMT

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

Re: Show Dimension with NULL value in Bar Chart

beck_bakytbek — Mon, 27 Feb 2017 15:28:50 GMT

Hi Wolfgang,

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

i hope that resolves your issue

beck

Re: Show Dimension with NULL value in Bar Chart

sureshsindhigi — Mon, 27 Feb 2017 15:46:40 GMT

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.

Re: Show Dimension with NULL value in Bar Chart

Frank_Hartmann — Mon, 27 Feb 2017 15:52:16 GMT

try to add this as expression:

avg({1}1/1)

and make the expression invisible or just use

this as expression:

count(Aufl.....)+ Avg({1} 0)

hope this helps

Re: Show Dimension with NULL value in Bar Chart

Anonymous — Mon, 27 Feb 2017 16:09:23 GMT

Hi Suresh,

unfortunately there is nothing attached.

Re: Show Dimension with NULL value in Bar Chart

sureshsindhigi — Mon, 27 Feb 2017 16:12:54 GMT

Hi Wolf,

I have attached, but I don't know..why you're not seeing it. 🙂

let me send you again. !!

Regards,

Suresh Sindhigi