Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

wanted to display the summarized value as dynamic label

Hi

i wanted to display the summarized value in one label, the value in the label should dynamic based on the selection.

please refer to the attached image that i found in some qlikview demo dashboards.

and also need to display the $ symbol before the text

Can any one please help me in that.

Thanks in advance

Untitled.jpg

1 Solution

Accepted Solutions
michael_maeuser
Partner Ambassador
Partner Ambassador

in the textbox:

='$ ' & sum(yourexpression)

View solution in original post

7 Replies
Not applicable
Author

i got the value in text box, now i can not able to display the $ symbol can anybody please help in that.

thanks

Not applicable
Author

use '$'

Not applicable
Author

I tried it, i created the formula for value, i tried to add $ symbol by using concatenation and also i tried with '+' symbol, but it did not work.

michael_maeuser
Partner Ambassador
Partner Ambassador

in the textbox:

='$ ' & sum(yourexpression)

michael_maeuser
Partner Ambassador
Partner Ambassador

no + sign, you need to add an &, like in my example

Not applicable
Author

Hi,

please try

    = Money(YourExpression,'$#,##0')      or       ='$ '  &(YourExpression)

Good luck!

Rainer

Not applicable
Author

got it,

thank you so much