topic Re: Chart object does not show all values from dimension but Table box does in QlikView

Chart object does not show all values from dimension but Table box does

rpavan17 — Wed, 27 Sep 2017 08:29:00 GMT

I have a table box which shows all values from dimensions. But, when i try to show the same data in bar chart it shows only few values from same dimension.

Can you suggest?why it happens?

Re: Chart object does not show all values from dimension but Table box does

Frank_Hartmann — Wed, 27 Sep 2017 09:40:33 GMT

can you upload a small sample-qvw which shows your problem?

Re: Chart object does not show all values from dimension but Table box does

shraddha_g — Wed, 27 Sep 2017 09:46:04 GMT

Can you share screenshot

Re: Chart object does not show all values from dimension but Table box does

rpavan17 — Wed, 27 Sep 2017 10:45:14 GMT

There is expense list and it has amount in the same line in excel sheet. it chart object it shows only one expense type

Re: Chart object does not show all values from dimension but Table box does

effinty2112 — Wed, 27 Sep 2017 10:49:29 GMT

Hi Pavan,

In the Presentation tab uncheck the option to Suppress Zero-Values.

Hope this helps

Regards

Andrew

Re: Chart object does not show all values from dimension but Table box does

rpavan17 — Wed, 27 Sep 2017 10:54:26 GMT

Good to see all fields but there are individual entries which does not show.

Re: Chart object does not show all values from dimension but Table box does

rpavan17 — Wed, 27 Sep 2017 11:00:32 GMT

To add on this,PTU has only 1 line in the excel which shows here..Other expense types having multiple lines

Re: Chart object does not show all values from dimension but Table box does

Frank_Hartmann — Wed, 27 Sep 2017 11:36:55 GMT

try using

sum([Appoved Amount]) as Expression in your chart

Re: Chart object does not show all values from dimension but Table box does

rpavan17 — Wed, 27 Sep 2017 11:49:26 GMT

Great.. Working.. Thanks