topic Re: Passing only one value from multiple current selections to an alternate state in QlikView

Passing only one value from multiple current selections to an alternate state

drewwilliams — Wed, 22 Jul 2015 17:54:53 GMT

Hi Everyone,

I'm pretty new to QlikView and have been browsing the forums for hours looking for a solution to my problem.

I currently have 4 states including my default state (default state, StateA, StateB, and StateC). Each state has the same list box of values. I want to be able to select 3 items in my default state list box and have these 3 items dispersed between the 3 states.

For example, if item 1, 2, and 3 are selected in the default state, then I want only item 1 selected in StateA, only item 2 selected in StateB, and only item 3 selected in StateC.

I've tried using triggers but I can't seem to figure out how to parse the selections between each state.

All help is appreciated!

Thanks,

Drew

Re: Passing only one value from multiple current selections to an alternate state

ramoncova06 — Wed, 22 Jul 2015 18:50:28 GMT

will you always have three selections for the same field ? if not what would you expect to show ?

Re: Passing only one value from multiple current selections to an alternate state

drewwilliams — Wed, 22 Jul 2015 19:01:01 GMT

There may be more than three selections for that field since there are more than 100 items that can be selected. I have the listbox sorted by item volume so the selected item with the highest volume is first down to the selected item with the lowest volume.

From the current selected items, I would always want the listbox in StateA to have the item with the highest volume selected, StateB to have the second highest volume item selected, and StateC to have the third highest volume item selected. So basically the top three current selected items parsed into each state.

Re: Passing only one value from multiple current selections to an alternate state

Qrishna — Wed, 22 Jul 2015 20:50:52 GMT

See Attached.

Hope that helps.

Cheers

Re: Passing only one value from multiple current selections to an alternate state

swuehl — Wed, 22 Jul 2015 20:58:07 GMT

Maybe like this?

Re: Passing only one value from multiple current selections to an alternate state

drewwilliams — Wed, 22 Jul 2015 20:59:34 GMT

That is close Krishna, but in your file, lets say I select items EAF1, EAF2, and EAF3. I want the button to then parse those selections so S1 selects EAF1, S2 selects EAF2, and S3 selects EAF3.

So all states have all of the items listed as options. When any number of items are selected in the default state, I want the first state to select the top item, the second state to select the second item, and the third state to select the third item from the selected default state list.

Re: Passing only one value from multiple current selections to an alternate state

drewwilliams — Wed, 22 Jul 2015 21:22:55 GMT

Yes!! Thank you so much, this is exactly what I was looking for and even better without the need for a button! I really appreciate you taking the time to help me solve this.

Cheers!

Re: Passing only one value from multiple current selections to an alternate state

Thu, 23 Jul 2015 07:59:21 GMT

Swuehl , if possible could you please explain us how you did it.

Regards

john

Re: Passing only one value from multiple current selections to an alternate state

swuehl — Thu, 23 Jul 2015 08:04:05 GMT

Look at the Dim2 field event trigger actions in Settings - Document properties - Triggers.

Re: Passing only one value from multiple current selections to an alternate state

Thu, 23 Jul 2015 11:24:58 GMT

Thanks Swuehl.

Re: Passing only one value from multiple current selections to an alternate state

drewwilliams — Thu, 23 Jul 2015 17:46:18 GMT

I noticed the max default item selection is 6, even though I will only be passing the top three items to the alternate states, how can I allow the user to select more than 6 items initially?

Re: Passing only one value from multiple current selections to an alternate state

swuehl — Thu, 23 Jul 2015 17:59:26 GMT

Sorry, where have you seen this limitation when you are selecting in a list box?

Re: Passing only one value from multiple current selections to an alternate state

drewwilliams — Fri, 24 Jul 2015 12:51:06 GMT

Nevermind, it was an issue within my variable which is defined with GetFieldSelections and if you do not choose a maximum values number then the default is 6.

Thanks again, your method works great!