topic Re: Create dynamic text box values in QlikView

Create dynamic text box values

Thu, 25 Jun 2015 04:16:29 GMT

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"

'CONTACT_TYPE' == "xx_EnquireBillConsumer"

'CONTACT_TYPE' == "xx_EnquireConsumer"

'CONTACT_TYPE' == "xx_EnquireBillMobileNewAdopter"

'CONTACT_TYPE' == "xx_ConnectPrepaidMobile"

Re: Create dynamic text box values

rwunderlich — Thu, 25 Jun 2015 05:40:08 GMT

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

Re: Create dynamic text box values

danieloberbilli — Thu, 25 Jun 2015 05:42:39 GMT

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)

Re: Create dynamic text box values

Thu, 25 Jun 2015 05:44:56 GMT

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

Re: Create dynamic text box values

Thu, 25 Jun 2015 05:52:22 GMT

Thanks to you both. Works perfectly.

Re: Create dynamic text box values

danieloberbilli — Thu, 25 Jun 2015 06:02:49 GMT

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