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

Format expression in text caption listbox

Hi, I'm trying to have the result of a count aligned right in the caption of listbox while the text remains left aligned.

qv_img5.PNG.png

Is it possible? I could add some hard spaces but that will only give a nice result as long as the amount of digits of the counted result remains unchainged.

Thanks for any help.

Hugo

4 Replies
MK_QSL
MVP
MVP

='ProductType ' & '(' &COUNT(Product_ProductType_Code)&')'

Not applicable
Author

To put the number between parentheses is a work around of course.

Nice idea though. Will do it this way for now.

Thank you!

Gysbert_Wassenaar

You can try mucking about with the len and repeat functions. Or you can simply use text boxes instead.


talk is cheap, supply exceeds demand
Not applicable
Author


Thank you for the suggestions. I'm new at qv and not yet familiar with these functions.

Will play with it to see where it takes me but I like the work around with the parentheses which I have implemented for now.

thanks,

Hugo