topic Anyone else having problems with alternate states in QlikView

Anyone else having problems with alternate states

Tue, 16 Dec 2014 15:06:23 GMT

I am trying to use Alternate States to handle comparisons of two metrics. I can get the expressions to work fine but I wanted to limit the list box values of one state based on certain values of the other state. I am trying to use the column expression functionality in the list box. Every time I try it, it seems to just ignore the alternate state value in the set analysis for the . Has anyone else been able to get that working?

Re: Anyone else having problems with alternate states

alexandros17 — Tue, 16 Dec 2014 15:07:07 GMT

send us an example ...

Re: Anyone else having problems with alternate states

Tue, 16 Dec 2014 16:18:59 GMT

This is a small app the shows what I am trying to do. The Benchmark Item list box is the one to focus on. I am trying to get the list of items to adhere to the selection of Category for the alternate state of [Current], the list box called Current Category. I have tried several variations of alternate state logic (not an expert yet by any means) but can't seem to get it to work. I think it has something to do with having to use an aggregate function with set analysis.

I was, however, able to use if logic with a variable to get the values. you will see it commented out in the expression editor.

thanks for any help.

Re: Anyone else having problems with alternate states

alexandros17 — Tue, 16 Dec 2014 16:52:24 GMT

I've seen your example, but I do not understand why to use alternate states?

What is your objective?

Explain better.

Re: Anyone else having problems with alternate states

Tue, 16 Dec 2014 17:06:51 GMT

In the real example there are several other filter selections that should only be applied to either the Current or Benchmark alternate states (unlike category in my example posted). An example is Organization structure. Say I am looking at productivity numbers between a team (selected on current state side) and a group (selected on the benchmark state side). I want the user to have that type of flexibility.

Regardless of whether this is the optimal solution or not for using alternate states and meeting my objective, I would like to know how you could do it this way

The main question here is how to you format your expression to show list box values based on selections from another state.

Re: Anyone else having problems with alternate states

jerem1234 — Tue, 16 Dec 2014 20:18:11 GMT

Try:

=aggr(only({Current}Item), Item)

for the expression in the listbox

Hope this helps!

Re: Anyone else having problems with alternate states

Tue, 16 Dec 2014 20:29:25 GMT

that was it. thank you very much!!