topic Re: Dynamic text box in QlikView

Dynamic text box

Anonymous — Wed, 30 Jul 2014 13:28:26 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 box

crusader_ — Wed, 30 Jul 2014 13:42:46 GMT

Hi,

Add "Field" Listbox (Check option: Always One Selected Value).

Expressions for your text objects are:

=only({<Level={0}>}Description) // For Level 0

=only({<Level={1}>}Description) // For Level 1

=only({<Level={2}>}Description) // For Level 2

=only({<Level={3}>}Description) // For Level 3

=only({<Level={4}>}Description) // For Level 4

=only({<Level={5}>}Description) // For Level 5

Hope this helps.

Regards,

Andrei

Re: Dynamic text box

Anonymous — Wed, 30 Jul 2014 15:33:21 GMT

It works, Thanks very much for the help!!!

Re: Dynamic text box

Fri, 01 Aug 2014 18:05:48 GMT

plz attach a sample qvw