topic Re: Cycle through values in a variable in QlikView

Cycle through values in a variable

Anonymous — Thu, 01 Oct 2015 18:54:48 GMT

I have created a variable with a set of values. These values are names in a field. I have created a drop down list with the variable the user can use to pick the fieldname of interest which feeds a chart.

Instead of a drop down however, I would like to create a "forward"/"backward" button that would advance through the selections. Any ideas on how to accomplish?

Re: Cycle through values in a variable

m_woolf — Thu, 01 Oct 2015 19:22:08 GMT

see the attached qvw

Re: Cycle through values in a variable

Anonymous — Thu, 01 Oct 2015 19:39:40 GMT

nice and very close. Last step would be to have it select the item. vTest is a list of names that belong to an actual field. Its a subset (in your example a-i would be a subset of a field that had a-z).

Re: Cycle through values in a variable

m_woolf — Thu, 01 Oct 2015 19:42:58 GMT

I displayed the result in a textbox.

You can create another variable and set it's value to the expression in the textbox.

That would produce the same results as an input box with dropdown list of items.

Re: Cycle through values in a variable

m_woolf — Thu, 01 Oct 2015 19:44:37 GMT

=concat(Yourfield,';') would produce the concatenated string of field values.

Re: Cycle through values in a variable

Anonymous — Thu, 01 Oct 2015 20:11:20 GMT

Right but I want it to select the item. I agree if I send the result to another variable and use that variable in a listbox expression it creates a listbox with that one item to select. I want it to select the item.

I tried using select in field using the search string =subfield(vTest,',',1) but it would not select the item in the '1' position (or any position). Thoughts?

Re: Cycle through values in a variable

Anonymous — Thu, 01 Oct 2015 20:19:21 GMT

Ok, I finally got it to work. I had to get rid of the quotes I had around each name. Thanks for your help!