topic Re: Dynamic Text Object Content in QlikView

Dynamic Text Object Content

Mon, 02 Jul 2012 17:32:14 GMT

Is it possible to load the text box object content via a simple equivalent of an include statement, or similar - from an external disk file ?

I know you can use variable expansion but the text I would to include is lengthy and not in a format that lends itself to using a variable. In addition I would like to retain the text itself rather than using a binary image copy.

Thanks

Andrew.

Re: Dynamic Text Object Content

Mon, 02 Jul 2012 18:10:00 GMT

Just to make sure, do you want to load the text in real time?

You could make the reading of this file in the loading script into a table (a table only with the texts)

NAME , TEXT

HELP1, dsajhdkjashdjkashjkdhasd

HELP2, kdhlaskd kalsjdklasdklashdlkashdjkhnakjn

and use the only function to show them correctly

in a text controller

= Only( {<NAME = {'HELP1'}>} TEXT )

Re: Dynamic Text Object Content

Mon, 02 Jul 2012 19:05:04 GMT

Thanks for the suggestion. This is similar to using variables - the main issue being that the help text is long and contains the file delimiters. I will try using your suggestion as a workaround maybe with a different help file per text object ( basically one per sheet ). I will also look at submitting an "Idea" for text object content as it seems such an elementary feature given that image content is already provided ! Regards. Andrew.

Re: Dynamic Text Object Content

Mon, 02 Sep 2013 03:25:04 GMT

I've found this to be very helpful indeed. I put several text boxes in a container and could get quite a lot of information on the KPIs, definitions and Business Rules in the dashboard.

Re: Dynamic Text Object Content

Anonymous — Wed, 30 Jul 2014 13:26:46 GMT

I have a table with 3 fields Level (1-5), Fields & description and I want to to create 5 text boxes (1 for each level) and want to change the description according to what is selected in the field column. I can't use conditional show as I want to display all 5 boxes when 1 field is selected and want to change the descriptions when another value in the field column is selected.

Please help me out in this?

Here my sample data:-

Level	Field	Description
0	Field 1	Aenean a sem et risus interdum gravida.
0	Field 2	Aenean mollis ligula eu nunc eleifend mattis.
0	Field 3	Aenean nec sapien volutpat sem sodales auctor.
0	Field 4	Aenean posuere lacus et elementum ornare.
0	Field 5	Aenean pulvinar risus id tortor lobortis, ac feugiat quam tempus.
0	Field 6	Aenean tempus tortor sit amet eleifend dictum.
1	Field 1	Aliquam cursus mauris sed condimentum adipiscing.
1	Field 2	Aliquam iaculis ligula sed lorem rhoncus lobortis.
1	Field 3	Aliquam id lectus ornare, mattis purus a, adipiscing nunc.
1	Field 4	Aliquam lacinia neque et risus gravida viverra.
1	Field 5	Aliquam lacinia nisl quis dignissim dignissim.
1	Field 6	Aliquam quis neque in diam interdum tempus ut at est.

Many Thanks,

Mohammad.

Re: Dynamic Text Object Content

Anonymous — Fri, 10 Jun 2016 02:33:49 GMT

Hi Mohammad, I have similar question about text in Qlik Sense.

My sample data is:

Level Field

fruit apple

food rice

meat fish

When I select from level, the Qlik Sense Text&image will Field information. For example, if I select fruit, Text&image will show 'apple'; if I select fruit and food, Text&image will show ' apple rice'.

I use Text&image expression, and put Field at expression. If I only select 1 from Level, Text&image will show Field information correctly, but If I select more than 1 from Level, Text&image will not show Field information.

How did you solve your question?

Could you please give any suggestion?

Thanks!