Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
drewwilliams
Contributor III
Contributor III

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

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

12 Replies
ramoncova06
Specialist III
Specialist III

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

drewwilliams
Contributor III
Contributor III
Author

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.

krishna_2644
Specialist III
Specialist III

See Attached.

Hope that helps.

Cheers

swuehl
MVP
MVP

Maybe like this?

drewwilliams
Contributor III
Contributor III
Author

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.

drewwilliams
Contributor III
Contributor III
Author

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!

Not applicable

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

Regards

john

swuehl
MVP
MVP

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

Not applicable

Thanks Swuehl.