topic Re: Data Point Value is not completely visible in a Bar Chart with a Log Scale in QlikView

Data Point Value is not completely visible in a Bar Chart with a Log Scale

vvira1316 — Thu, 06 Jul 2017 19:38:58 GMT

Hi,

One of the bar value is not completely visible in a bar chart with logarithmic scale. Please review the screen shot. Any help or guidance.

Thanks,

Vijay

Re: Data Point Value is not completely visible in a Bar Chart with a Log Scale

vishsaggi — Thu, 06 Jul 2017 20:03:44 GMT

Try to use Ctrl+Shift and reduce or expand the chart area?

Re: Data Point Value is not completely visible in a Bar Chart with a Log Scale

vvira1316 — Thu, 06 Jul 2017 20:32:12 GMT

Thanks for your reply. I've already tried it but it didn't work.

Re: Data Point Value is not completely visible in a Bar Chart with a Log Scale

vishsaggi — Thu, 06 Jul 2017 20:40:08 GMT

Can you share you sample app to look into? Not visible you mean the number? Can you see any scroll bar in the bottom?

Re: Data Point Value is not completely visible in a Bar Chart with a Log Scale

vvira1316 — Thu, 06 Jul 2017 22:35:47 GMT

here is the data set that you can use in QVW file The window size 575 Width and 300 Height. If I increase the width long enough then I'm seeing it but I can't increase the size that much due to other charts on the page and layout.

Trading Entity	EntityCount
Trading Entity USA One	15473
Trading Entity BrazilSA Two	1616
Trading Entity North America APAC EMEA Three	188
Trading Entity Brazil Two	181
Trading Entity BrazilSA Four	110
Trading Entity-1 Five	77
Trading Entity1 Six	75
Trading Entity West Four	21
Trading Entity IndonesiaKorea Nine	16
Trading Entity China	11
Trading Entity Canada	10
Trading Entity Netherland	9
Trading Entity Germany	7
Trading Entity Pacific Island	6
Trading one	6
Trading Entity Afghanistan	6
Trading Entity Australia SE NEWS CORP CNN	5
Trad Entity	4
Trading Entity Chile SA	3
Trading Entity Panama	2
Trading Entity South Africa S.A.	1

Re: Data Point Value is not completely visible in a Bar Chart with a Log Scale

vishsaggi — Fri, 07 Jul 2017 01:33:52 GMT

Hmm. Not sure if we have any option to supress that. Cant you do plot values inside segments or do a Grouped chart style. Like

I mean uncheck Log scale in Axes tab and see like above. If not can you do text on axis and plot values inside segments. Like below:

Re: Data Point Value is not completely visible in a Bar Chart with a Log Scale

tajmohamed30 — Fri, 07 Jul 2017 02:41:36 GMT

have you tried reducing the font size

Re: Data Point Value is not completely visible in a Bar Chart with a Log Scale

vvira1316 — Fri, 07 Jul 2017 14:36:38 GMT

It is already small font due to thin bars.

Re: Data Point Value is not completely visible in a Bar Chart with a Log Scale

vvira1316 — Fri, 07 Jul 2017 14:38:18 GMT

I had tried values inside bar but most likely users will not like it as it will not be consistent with other charts. I'll provide the options and have them chose one that they will like to have.

thanks for your inputs

Re: Data Point Value is not completely visible in a Bar Chart with a Log Scale

tajmohamed30 — Fri, 07 Jul 2017 16:25:23 GMT

I have tried it in Qlikview 12.10 and it display all the numbers(15473) even if you shrink it to small.

Re: Data Point Value is not completely visible in a Bar Chart with a Log Scale

vvira1316 — Fri, 07 Jul 2017 17:48:29 GMT

Nice to know. We are using QV 11.20. Thanks for the info.

Re: Data Point Value is not completely visible in a Bar Chart with a Log Scale

vishsaggi — Fri, 07 Jul 2017 17:52:04 GMT

Or use a container object and try to stretch the graph inside it or add other graphs too inside the container that way you have space in your sheet and also stretch the graph.

Re: Data Point Value is not completely visible in a Bar Chart with a Log Scale

tajmohamed30 — Sat, 08 Jul 2017 09:20:06 GMT

Qlik have made some improvements prior to the old version, you can update your qlikview for better performance of your dashboard creation and if you having the licensed version it pertains.

Re: Data Point Value is not completely visible in a Bar Chart with a Log Scale

vvira1316 — Tue, 22 Aug 2017 19:59:42 GMT

By setting StaticMax 3 times the max bar value I was able to get it displayed.