topic Re: Need help in number format in QlikView

Need help in number format

Mon, 28 Apr 2014 10:34:24 GMT

Hi All,

I have strucked in converting the number format, My chart expression is giving the values like 2359526 and my expression for this value is if(Flag='US',Sum(Uvol), Sum(Ivol)) but I need to convert this number to 2,359K (need to add k end of the number). Please suggest me a idea for this.

Re: Need help in number format

alexandros17 — Mon, 28 Apr 2014 10:35:54 GMT

just write

if(Flag='US',Sum(Uvol), Sum(Ivol)) & 'K'

Re: Need help in number format

rustyfishbones — Mon, 28 Apr 2014 10:36:34 GMT

NUM( if(Flag='US',Sum(Uvol), Sum(Ivol)),'#,##0K')

Re: Need help in number format

its_anandrjs — Mon, 28 Apr 2014 10:38:29 GMT

You can write this way

=Num( if(Flag='US',Sum(Uvol), Sum(Ivol))

,'#,##0K' )

Re: Need help in number format

tresB — Mon, 28 Apr 2014 10:44:35 GMT

Divide amount by 1000 and change the number format like:

Num( if(Flag='US',Sum(Uvol), Sum(Ivol)) /1000 , '#,##0K' )

Re: Need help in number format

MK_QSL — Mon, 28 Apr 2014 10:45:21 GMT

=NUM(YourExpression/1000,'#,##0K')

Re: Need help in number format

nizamsha — Mon, 28 Apr 2014 10:50:06 GMT

if(Flag='US',num(Sum(Uvol)/1000,'#,##0K'), num( Sum(Ivol)/1000,'#,##0K'))

Re: Need help in number format

Mon, 28 Apr 2014 10:56:44 GMT

Thanks for your quick help.