topic title boxes, with variable, over a chart in QlikView

title boxes, with variable, over a chart

becki_kain — Wed, 25 Nov 2020 16:16:04 GMT

please see enclosed workflow. I need to put the value of the variable TP1 somehow centered over the columns BB1-BB4 and then the value of TP2 centered over BB5-BB9. If i could do this in the title of the chart "industry3" that would be great, but if i can't, I could do it as a text box. I tried just a text box with the text =$(TP1) but that just gives me a blue box with a dot in it. I'm sure this is really easy - ideas? thanks

becki kain

Re: title boxes, with variable, over a chart

trdandamudi — Tue, 14 Nov 2017 18:17:15 GMT

In the title paste the below expression:

=TP1 &',' &TP2

If you want to center it then follow the below screen shot:

Re: title boxes, with variable, over a chart

becki_kain — Tue, 14 Nov 2017 18:24:51 GMT

how do I add text to the variables though? one needs to just be =TP1 and one needs to be "retail share is =TP2" and i cant seem to get the text part to work. thanks

Re: title boxes, with variable, over a chart

becki_kain — Tue, 14 Nov 2017 18:31:23 GMT

the spacing is still off, i need the first value to be over the first 4 numeric columns and the next over the next 4 columns. is that possible?

so far, i have this

=TP1& 'Retail Share '&TP2

and that gets me the data but not the spacing. how do you know where to put the &?

thanks

Re: title boxes, with variable, over a chart

trdandamudi — Tue, 14 Nov 2017 18:38:55 GMT

Use the below expression: (Adjust spaces as you need)

=TP1 &' ' &'Retail Share '&TP2

Re: title boxes, with variable, over a chart

becki_kain — Tue, 14 Nov 2017 19:02:58 GMT

thanks! that works. i'm still confused though as to where you put & in variable expressions . is there a write up somewhere of that?

Re: title boxes, with variable, over a chart

trdandamudi — Tue, 14 Nov 2017 19:29:16 GMT

Glad I am able to help you...

Let me break it down the expression:

=TP1 &' ' &'Retail Share '&TP2

TP1 <---- will get the value from the field

&' ' <--- & is to concat. It is concatenating spaces here

&'Retail Share ' <--- again you are using &, meaning concat 'Retail Share'

&TP2 <--- Once again you are concatenating the value of TP2 here.

Note: & <-- it is like concat or join. By using the ampersand you are joining different values.

String Operators

Hope this helps...