Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
mariarosab
Contributor II
Contributor II

Text Object with variables - Formatting

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 !

4 Replies
maverjannet
Specialist
Specialist

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.

mariarosab
Contributor II
Contributor II
Author

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
Partner
Partner

Hi,

Please share a sample Qvw for better suggestion.

Thanks

Raja

maverjannet
Specialist
Specialist

You welcome Marie Billaud