topic How to get previous selection of a list box? in QlikView

How to get previous selection of a list box?

Anonymous — Fri, 23 Oct 2015 09:45:49 GMT

HI all,

I have a listbox.

Color
Blue
Black
Orange
Green
Red
Yellow

And 2 text objects, one showing the current selection of color and the other showing the previous selection.

So is it possible to get the previous selection, without using macro?

Kindly suggest.

Re: How to get previous selection of a list box?

qlikviewwizard — Fri, 23 Oct 2015 12:59:41 GMT

You can achieve by using :

1) Set Analysis

2) Click on BACK

3) Bookmark

Hope this will help you.

Re: How to get previous selection of a list box?

sunny_talwar — Fri, 23 Oct 2015 13:02:56 GMT

May be this:

=Only({$1} Color) for one selection

=Concat({$1} Color, ', ') for multiple selections

Re: How to get previous selection of a list box?

Anonymous — Fri, 23 Oct 2015 14:21:52 GMT

Thank you Sunny for the solution.

The problem with my application is that a particular trigger is causing set analysis to fail. Because of this particular trigger (which sets a variable dynamically), which i cant remove, $ and $1 are showing same result.

Re: How to get previous selection of a list box?

sunny_talwar — Fri, 23 Oct 2015 15:06:21 GMT

Would you be able to share a sample? Without looking at it, won't be able to provide much help.

As a second thought, may be try this {$2} or {$3}

Re: How to get previous selection of a list box?

Anonymous — Mon, 08 Feb 2016 05:09:10 GMT

Thank you. It worked at {$10}

Re: How to get previous selection of a list box?

oknotsen — Mon, 08 Feb 2016 08:42:53 GMT

If your question is now answered, please flag the Correct Answer (and possible Helpful Answer).

If not, please make clear what part of your question still needs help.