topic Format expression in text caption listbox in QlikView

Format expression in text caption listbox

Wed, 12 Nov 2014 14:11:52 GMT

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

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

Re: Format expression in text caption listbox

MK_QSL — Wed, 12 Nov 2014 14:26:29 GMT

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

Re: Format expression in text caption listbox

Wed, 12 Nov 2014 14:34:28 GMT

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

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

Thank you!

Re: Format expression in text caption listbox

Gysbert_Wassenaar — Wed, 12 Nov 2014 14:38:03 GMT

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

Re: Format expression in text caption listbox

Thu, 13 Nov 2014 08:06:33 GMT

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