Create dynamic text box values

[#1]

Hi,

I'm new to qlikview so was not very sure if this is possible.  I'm attempting to create a selection text box for my qlikview line graph. (There are other text boxes as well). The field I want displayed and filtered is 'Contact Type'. There are many values for Contact type, however I want only to displayed with the following.

Is there a way to achieve this within the text box expression or by another way. If so please provide guidance. Thanks,.

'CONTACT_TYPE' == "xx_DisputeBillConsumer"

or

'CONTACT_TYPE' == "xx_EnquireBillConsumer"

or

'CONTACT_TYPE' == "xx_EnquireConsumer"

or

  'CONTACT_TYPE' == "xx_EnquireBillMobileNewAdopter"

or

   'CONTACT_TYPE' == "xx_ConnectPrepaidMobile"

[rwunderlich · Accepted solution]

In the listbox, on the General tab, select "<Expression>" in the Field dropdown. And then enter an expression like this:

=if(match(CONTACT_TYPE

,'xx_DisputeBillConsumer'

,'xx_EnquireBillConsumer'

,'xx_EnquireConsumer'

)

,CONTACT_TYPE)

-Rob

http://masterssummit.com

http://robwunderlich.com

[danieloberbilli]

If you are talking about a Listbox:

From the general tab of the listbox, choose Field <Expression> (bottom of all fields in the fields dropdown)

then write:

if(Match(CONTACT_TYPE,

  'xx_DisputeBillConsumer',

  'xx_EnquireBillConsumer',

  'xx_EnquireConsumer',

  'xx_EnquireBillMobileNewAdopter',

  'xx_ConnectPrepaidMobile'

  ),CONTACT_TYPE)

[#4]

Thanks a lot. I'll try the solution provided and let you know.

[#5]

Thanks to you both. Works perfectly.

[danieloberbilli]

Good to hear. Please mark rwunderlich 's answer as correct to help other users to find the solution right away