Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Alternative for shorting large numbers in Graphs

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?

Tags (3)
2 Replies
rajeshvaswani77
Valued Contributor III

Re: Alternative for shorting large numbers in Graphs

See if log scale would be helpful.

thanks,

Rajesh Vaswani

Or
Valued Contributor II

Re: Alternative for shorting large numbers in Graphs

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.

Community Browser