Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
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