topic Pick/Match and Current Selections in QlikView

Pick/Match and Current Selections

Fri, 21 Oct 2011 15:36:20 GMT

Hello-

I'm using pick/match for a few fields. My object shows the new value. However, when these fields are selected, the current selections box shows the original value. Is there a way I can fix this? I'm not opposed to using a text box and creating a new current selections box. Can this be done? Thanks in advance!

-Tina

Pick/Match and Current Selections

Fri, 21 Oct 2011 15:42:29 GMT

can you post here what you have in your pick-match statement.

Pick/Match and Current Selections

Fri, 21 Oct 2011 15:54:10 GMT

I want the current selections box to show WFCC, instead the box shows East North Central.

=pick(match(Division,'East North Central','East South Central','Middle Atlantic','Mountain','Pacific'),'WFCC','WFHM','WFCS','WDDA','WFHE')

Re: Pick/Match and Current Selections

Fri, 21 Oct 2011 16:22:55 GMT

Hi Tina: check the attached qvw. The pick match is in the script...hope this works for you.

Pick/Match and Current Selections

Fri, 21 Oct 2011 19:09:54 GMT

Can I do this outside of the load script though?

Pick/Match and Current Selections

Miguel_Angel_Baeyens — Fri, 21 Oct 2011 19:15:45 GMT

Hi there,

Pick() and Match() are function that can be used in the script as well as in any other expression editor (expressions in charts, text boxes, listboxes...).

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Pick/Match and Current Selections

Fri, 21 Oct 2011 19:17:19 GMT

Yes...outside the script - say in a chart - your statement should work as is. So when you drag in the Division into the dimensions, click the Edit button and paste your statement in there. It should work fine.

Pick/Match and Current Selections

Fri, 21 Oct 2011 19:21:06 GMT

Miguel: is there a way I can use pick and match functions..maybe the same statement as above - in a list box. I always felt I could not do so....

thanks!

Pick/Match and Current Selections

Miguel_Angel_Baeyens — Fri, 21 Oct 2011 19:24:22 GMT

Hi,

Yes! create a new object, listbox, and instead of a field, select from the drop down "<Expression>" (is at the bottom of the list of fields). Precede the expression with the "=" sign and that's it!

Regards.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Pick/Match and Current Selections

Fri, 21 Oct 2011 19:25:47 GMT

Yup..got it! thanks!

Pick/Match and Current Selections

Fri, 21 Oct 2011 19:34:44 GMT

I think my original question got sidetracked. I used a pick/match statement to create a new values for a particular field. When I click on these new values my current selection box shows the old values not the new values. In the pictures below is an example. I would like the current selections to read Fields = Affiliate and Values = WFHE. Is there a fix for this outside of the load script?

Pick/Match and Current Selections

Miguel_Angel_Baeyens — Fri, 21 Oct 2011 19:43:18 GMT

Tina,

The current selections object always shows (and only) the actual field names and values. If you want to show something different you can create two fields in the script, as JasleenP_SR suggested above, one with the actual value, the other one with the value you want to show, and use the latter for selections. Actually is quite usual, for example, Item No and Item Description. (Use the numeric code in set analysis and expressions, but show the user the more familiar Description).

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: Pick/Match and Current Selections

Fri, 21 Oct 2011 19:48:04 GMT

I'm attaching the qvw for your ref. tina....

Pick/Match and Current Selections

Fri, 21 Oct 2011 20:09:12 GMT

Thanks!