topic Re: Need to get comma in QlikView

Need to get comma

bharatkishore — Wed, 16 Jan 2013 07:05:45 GMT

Dear All,

I have created a pivot table chart and there some calculations. And i have value like 664,123,406. When i am trying to copy table to excel i am getting the value like 664123406(Without Comma).

Can you please tell me how to get the integer value with comma. I am copying the table to excel.

Regards,

RBK

Re: Need to get comma

Sokkorn — Wed, 16 Jan 2013 08:12:28 GMT

Hi RBK,

Try to format

1. Right click on pivot table ==> Properties ==> Number ==> Select <Number> in Number Format Settings

2. User expression: NUM(SUM(FieldValue),'#,##0.00')

3. And if above have no luck then the last one is TEXT(NUM(SUM(FieldValue),'#,##0.00'))

Try it and let me know.

Regards,

Sokkorn

Re: Need to get comma

bharatkishore — Wed, 16 Jan 2013 08:44:35 GMT

Thanks for the reply...I will update you once its completed.

Regards,

RBK