Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
See if log scale would be helpful.
thanks,
Rajesh Vaswani
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.