topic Formatting an integer in QlikView

Formatting an integer

Thu, 02 Jul 2009 20:57:04 GMT

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,

Formatting an integer

Thu, 02 Jul 2009 21:44:31 GMT

Go into the number tab and the choose 'integer'

and put K as thousand symbol.

That should make it.

Philippe

Formatting an integer

Thu, 02 Jul 2009 21:53:14 GMT

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

Formatting an integer

Thu, 02 Jul 2009 22:18:49 GMT

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.

Formatting an integer

Thu, 02 Jul 2009 22:29:15 GMT

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;