topic Re: Question on Text box content formatting options in QlikView

Question on Text box content formatting options

Qlik_Enthu — Thu, 27 Jul 2017 06:45:50 GMT

dear all, I have text box which will show some values based on calculations. I don't see formatting/style options to display the numbers. say for example if I am displaying a count and I wanted it to be in x,xxx,xxxx format. any idea on how to accomplish this?

regards,

sai

Re: Question on Text box content formatting options

settu_periasamy — Thu, 27 Jul 2017 06:51:10 GMT

Try with num(count(expression), '#, ###, ####') like that..

Re: Question on Text box content formatting options

arvind_patil — Thu, 27 Jul 2017 06:51:14 GMT

HI Saimeenakshi,

Please Try Below One:

=Num(sum(Value),'0,000,0000')

Thanks,

Arvind Patil

Re: Question on Text box content formatting options

arvind_patil — Thu, 27 Jul 2017 06:55:55 GMT

Hi Saimenakshi,

Please mark and close the thread .

Thanks,

Arvind Patil

Re: Question on Text box content formatting options

Qlik_Enthu — Thu, 27 Jul 2017 06:58:05 GMT

Thank you both!! it worked