topic Re: Expression/text label in QlikView

Expression/text label

Wed, 15 Jan 2014 20:57:51 GMT

Hi! I'd like to create a label to show a text like this: "150 - Company A", where 150 is a value selected from an input box,(vBusiness) and "Company A" is the name of number 150 company. How can I write this expression?

Is it correct the use of this expression?

='Title:' & ' ' & (vBusiness)& ' ' & ({$<NumberCompany ={$(=vBusiness)}>}[NameCompany])

Any suggestions greatly appreciated.

Regards,

Andrea

Re: Expression/text label

Gysbert_Wassenaar — Wed, 15 Jan 2014 20:59:18 GMT

Assuming that vBusiness is a variable that contains a numeric value... try this:

='Title: ' & $(vBusiness)& ' ' & only({$<NumberCompany ={$(vBusiness)}>}[NameCompany])

Re: Expression/text label

CELAMBARASAN — Wed, 15 Jan 2014 21:01:52 GMT

May be like this

='Title:' & ' ' & (vBusiness)& ' ' & Only({$<NumberCompany ={$(=vBusiness)}>}[NameCompany])

Re: Expression/text label

vipin_mishra479 — Thu, 16 Jan 2014 06:06:48 GMT

Hi,

Use This

='Title: ' & $(vBusiness)& ' - ' & only({$<NumberCompany ={$(vBusiness)}>}[NameCompany])