topic Alternative for shorting large numbers in Graphs in QlikView

Alternative for shorting large numbers in Graphs

Tue, 03 Sep 2013 10:27:58 GMT

Hello,

I am using the following code in my graph so numbers larger then 1000 will appear as 1K.

if(Sum([EndOfWeekStock]) > 1000,
  Num(Sum([EndOfWeekStock])/1000,'#.#0K'),
Sum([EndOfWeekStock]))

However, I sometimes have numbers larger than 1000 and smaller mixed. This results in really small values compared to the ones below 1000.

Is there another way to accomplish this?

Re: Alternative for shorting large numbers in Graphs

rajeshvaswani77 — Tue, 03 Sep 2013 10:29:18 GMT

See if log scale would be helpful.

thanks,

Rajesh Vaswani

Re: Alternative for shorting large numbers in Graphs

Or — Tue, 03 Sep 2013 11:17:56 GMT

Hello,

If you're looking to modify your graph's scale, you can use QlikView's built-in functionality for this. In the "Number" tab of the graph's properties, you can select a thousands, millions, and billions symbol (K,M,B, or whatever you prefer). This will adjust the graph's axis, but not the actual numbers.

If you need to adjust the actual numbers, I would recommend displaying everything in Ks - e.g. 0.01K for 10. It's not optimal, but it is the least confusing option I can think of for mixed values.