topic Re: Want to show some text and image simultaneously in TextBox in QlikView

Want to show some text and image simultaneously in TextBox

Thu, 09 Oct 2014 14:29:06 GMT

Hi,

I am new to Qlikview and trying to use Text Box and want to show some text and image in tha text box.eg

Text - "5.34%"

Image -(upward arrow/Downword arrow)

So,Is ther any way to show both togather in one Text box.

Thanks

Re: Want to show some text and image simultaneously in TextBox

Colin-Albert — Thu, 09 Oct 2014 14:33:05 GMT

You could put your text on the Caption row, with the image beneath.

You will need to use the num() function to format the number. e,g. num(<your field, '#,##0%')

The Caption row only supports a single line of text.

Re: Want to show some text and image simultaneously in TextBox

Thu, 09 Oct 2014 14:37:48 GMT

Hi expert,

can u explain little bit clear i am new to qv

if u dont mind?

Re: Want to show some text and image simultaneously in TextBox

Anonymous — Thu, 09 Oct 2014 14:38:48 GMT

My favourite solution to this is instead using CHR(9651) and CHR(9961) for the arrows.

IF(XX>YY,CHR(9651),CHR(9961) etc.

Much easier to work with than with pictures and quick in terms of performance.

Kind regards

Niklas

Re: Want to show some text and image simultaneously in TextBox

Thu, 09 Oct 2014 14:40:29 GMT

I think we can use either text or image at a time because we should choose corresponding representation property.

Regards,

Pooja

Re: Want to show some text and image simultaneously in TextBox

Thu, 09 Oct 2014 14:45:07 GMT

may i know what is chr(9651) and chr(9961)

Re: Want to show some text and image simultaneously in TextBox

Thu, 09 Oct 2014 14:45:19 GMT

Hi Niklas,

Thanks for such instant reply,Your solution is good but problem is these arrows will not do any good,as not interactive enough.Instead I will be forced to make to different textboxes,one for text and one for image.

Any other solution or suggestion??

Regards,

Palash

Re: Want to show some text and image simultaneously in TextBox

Anonymous — Thu, 09 Oct 2014 14:47:32 GMT

Here is a very ugly web site, but with very useful information for this kind of solution.

http://www.alanwood.net/unicode/geometric_shapes.html

Another favourite of mine is using just a colored CHR(9679) to highlight a warning with a red circle, an alert with an orange circle etc.

Kind regards

Niklas

Re: Want to show some text and image simultaneously in TextBox

Thu, 09 Oct 2014 14:49:53 GMT

Hi Colin,

Actually I need like "77.12%"then along with some Arrow Image, and if I use caption for text,I can't be able to align both in same line.Please Correct me if got your solution wrong.

Regards,

Palash

Re: Want to show some text and image simultaneously in TextBox

Thu, 09 Oct 2014 14:55:46 GMT

Hi Guys,

So Making two different text boxes is the only way?? Because That also will create lot of problem because it will be very difficult to make it look like one Text box??

Any Inputs??

Regards

Palash

Re: Want to show some text and image simultaneously in TextBox

Anonymous — Thu, 09 Oct 2014 14:55:54 GMT

I am not sure what kind of "interactivity" you want?

Coloring them is obviously possible.

If you just want a big dash board number and a real image I would be using two text boxes next to each other (no border and no visible background) and work with them individually.

Then you can of course add actions to the arrow image.

I would not recommend that solution though.

Kind regards

Niklas

Re: Want to show some text and image simultaneously in TextBox

Colin-Albert — Thu, 09 Oct 2014 14:56:20 GMT

The caption option means that the image will be below your text, but your original post did not specify having the image on the same line, just in a single text object.

To get the image and text on the same line then your only option is to use two text boxes, one for the text and another for the image and align then as required..

Re: Want to show some text and image simultaneously in TextBox

stigchel — Thu, 09 Oct 2014 15:25:08 GMT

Use a Straight table chart instead of a text box, one expression for the value and another for the (dynamic) picture. With the different styling options you can make it look like a single text object.

Re: Want to show some text and image simultaneously in TextBox

cspencer3 — Thu, 09 Oct 2014 16:31:12 GMT

Can you just set the arrow image as your background, and the text as a string/formula in the text field? I have done this before and it works.

Re: Want to show some text and image simultaneously in TextBox

mikecrengland — Thu, 09 Oct 2014 16:45:49 GMT

Hi Colin -

The caption can actually have more than one line... Select the 'Multiline Caption' option on the Caption tab and you can choose the number of 'rows' that you need.

mike

Re: Want to show some text and image simultaneously in TextBox

Colin-Albert — Thu, 09 Oct 2014 20:14:19 GMT

Thanks Mike. That's one option I've missed!

Re: Re: Want to show some text and image simultaneously in TextBox

stigchel — Fri, 10 Oct 2014 11:57:12 GMT

Attached a worked out sample qvw with a straight table chart