topic Re: Text Object with variables - Formatting in QlikView

Text Object with variables - Formatting

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

Hi everyone !

I would like to create a text object box using variables.

My issue is with the result's format.

I have 2 variables vFirst Text and vSalesThisMonth.

vFirstText

='Sales This Month'

vSalesThisMonth

=sum({$<Year = {$(=max(Year))}, Month_num = {$(=max(Month_num))}>}[Amount Sales Local]/(if(%Currency='Local',1,[EUR Rate]/100)))

Text Object:

=vFirstText&':'&vSalesThisMonth

Returns

Sales This Month : 1234567,1234567

I would like to format the total and get ''Sales This Month : 1 234 567''

Any ideas to fix this ?

Thanks & Best regards !

Anonymous — Wed, 20 Dec 2017 16:37:09 GMT

Hi,

you can try add the num format in your variable.

=Num(sum({$<Year = {$(=max(Year))}, Month_num = {$(=max(Month_num))}>}[Amount Sales Local]/(if(%Currency='Local',1,[EUR Rate]/100))),'#,##0')

Regards.

Anonymous — Thu, 21 Dec 2017 09:26:14 GMT

Hi Jannet,

Thank you for you reply

I changed it but it's not changing anything at all...

Then I tried: Num(vSalesLastMonth,'#,###,###,###')

And my result is 1234567,438,###,###

Do you know what I am doing wrong ?

Thanks for your help

arasaraja_cts — Thu, 21 Dec 2017 16:59:38 GMT

Hi,

Please share a sample Qvw for better suggestion.

Thanks

Raja

Anonymous — Fri, 22 Dec 2017 17:10:36 GMT

You welcome Marie Billaud