topic Re: Display Large Numbers in Charts in QlikView

Display Large Numbers in Charts

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

Hi,

Please find the attached QVW.

In the chart the expression values are too large (16 digits).

I want to show them in K(divided by 1000) $ M(divided by 1000000) by selecting appropriate button.

It is not showing properly sometimes it is showing only 4 digits and sometimes 10 digits..

How to show full numbers depend on K/M ?

Please look into this..

Thank You

Re: Display Large Numbers in Charts

mohan2391 — Mon, 06 Feb 2017 09:44:06 GMT

Please find the new QVW file (LESSER SIZE) not the old one..

Re: Display Large Numbers in Charts

sdmech81 — Mon, 06 Feb 2017 09:54:31 GMT

HI,

I can give you some idea on this, like how to do this:

*) Create variable say vDivider= 1000/1000000

*)Then suppose say there are 2 button/text objects u have to toggle between 1000 and 1000000.

*)Then in each button u set action of setting a variable value(i.e value for vDivider) either 1000/1000000 (fr 1button say it sets 1000 then othr will set 1000000)

*)Then use tht as variable vDivider for dividing.

Hope this helps!

Re: Display Large Numbers in Charts

mohan2391 — Mon, 06 Feb 2017 10:14:17 GMT

That is what my text objects on right side do.

$K - 1000

$M - 1000000

Even after dividing it is not showing properly that is the issue.

When I click on $K, it will be having 13 digits so it is not showing full number, only when i keep mouse on bars it is showing full numbers

Re: Display Large Numbers in Charts

sdmech81 — Mon, 06 Feb 2017 10:53:16 GMT

HI,

Fr me numbers were visible..

Can u take screen shot and high light the issue if u still feel so?

Sachin

Re: Display Large Numbers in Charts

avinashelite — Mon, 06 Feb 2017 11:45:45 GMT

Since you have bigger numbers ..the representation is getting over lap , since the numbers are big you need to educate the users to use $M because $K does't make sense here ..if you still need the numbers then increase the distance between the bars in Presentation

Hope this helps you

Re: Display Large Numbers in Charts

MarcoWedel — Tue, 07 Feb 2017 23:37:39 GMT

Hi,

maybe helpful:

Re: Number formatting - millions to billions

regards

Marco

Re: Display Large Numbers in Charts

sdmech81 — Wed, 08 Feb 2017 06:12:48 GMT

HI,

Better show text as pop-up in this case or make ur graph little large so tht values will not over lap:

Tick text as pop up and remove values on data points like in scree below: