Formatting an integer

[#1]

Hello,

Is it possible to specify a format in order to dump the value 1 000 000 as 1 000 k, without money. I have a bar chart with such values on the expression axis, I need values on the axis but not that long.

Thanks,

[#2]

Go into the number tab and the choose 'integer'

and put K as thousand symbol.

That should make it.

Philippe

[#3]

Thanks for your answer, but it doesn't work it dumps : 1 k000 k000 on the axis.

[#4]

That looks a little odd. Does your number in the data have spaces in between the thousands like this 1 000? In your load script, what is ThousandSep set to (it is the first line in my default load script)?

It seems like QlikView is getting confused at how your number is formatted.

[#5]

Here is the load script :

SET

ThousandSep=' ';

LigneCodifiees:

LOAD

The number I dump is NB_CODIF_LIGNE. On the Number panel of the document the, NB_LIGNE_CODIF is as Number, I set the format of the unmber panel of the graph.

*; SQL select numprog,trunc(DATCODIF,'DD') as DATECODIF,count(*) as NB_LIGNE_CODIF from ulysst_ligprog where (FLGCODIF='D' OR FLGCODIF='A' OR FLGCODIF='M') AND FLGREPART='R' group by trunc(DATCODIF,'DD'),NUMPROG;