topic Re: comma seperator in QlikView

comma seperator

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

i want the result for Number of deals with 1,000 seperator. with starting dollor symbol

like this: $1,405 .....

for hardware and service and total i need to remove the decimals

for example $818.90 is there i want to be $818 only remove the two decimals

prieper — Fri, 21 Sep 2018 12:13:43 GMT

If you need for display only: please use formatting option like "$#,##0.00" or "$#,##0".

If you really need to truncate the data you may use FLOOR(MyData) as expression. Formatting as above.

Peter

soniasweety — Fri, 21 Sep 2018 12:18:16 GMT

i want to display only... but my case its different i used value list with multiple measure type so unable to achieve it

soniasweety — Fri, 21 Sep 2018 12:23:43 GMT

working perfectly thank you

Frank_Hartmann — Fri, 21 Sep 2018 12:23:53 GMT

what should be displayed if you select Format = $-Billion

$0 ???

prieper — Fri, 21 Sep 2018 12:25:37 GMT

actually I do not see your problem:

within the expression you already differentiate (by valuelist) and format ...

soniasweety — Fri, 21 Sep 2018 12:25:41 GMT

whatever the number either its billion or million or thousand before number it should be dollor symbol

and count with be comma seperator. its working fine enough thanks.