Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

comma seperator

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

1 Solution

Accepted Solutions
prieper
Master II
Master II

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

View solution in original post

6 Replies
prieper
Master II
Master II

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

View solution in original post

soniasweety
Master
Master
Author

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

soniasweety
Master
Master
Author

working perfectly   thank you

Frank_Hartmann
Master II
Master II

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

$0 ???

prieper
Master II
Master II

actually I do not see your problem:

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

soniasweety
Master
Master
Author

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.