topic Number Symbol in QlikView

Number Symbol

Wed, 20 May 2015 20:59:32 GMT

I would like o include a symbol in a my straight table chart Sum(Value) to return symbol "K" for thousands, "M" for million next to the number in the table. How can I do this?

Re: Number Symbol

Colin-Albert — Wed, 20 May 2015 21:08:07 GMT

You will need to manually test the value and divide the value by 1000000 or 1000 then add the 'K' or 'M' within your expression.

The option on expressions for Thousand, Million and Billion symbols only work on image charts like bar or pie charts, they do not work on straight or pivot tables

Re: Number Symbol

swuehl — Wed, 20 May 2015 21:08:44 GMT

Maybe like described here.

Number format in espression

Re: Number Symbol

robert_mika — Thu, 21 May 2015 06:36:36 GMT

Try like this:

if(sum([# Air Time])<1000000,dual(sum([# Air Time]/1000)&' K',sum([# Air Time])/1000),dual(sum([# Air Time])/1000000&' M',sum([# Air Time])/1000000))

You need dual to return number.

or fallow Stefan suggestion which is very neat.

Re: Number Symbol

Thu, 21 May 2015 07:05:24 GMT

Divide it down then add in the Mn, Bn etc in the expressions.