Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Maybe like this?
will you always have three selections for the same field ? if not what would you expect to show ?
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.
See Attached.
Hope that helps.
Cheers
Maybe like this?
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.
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!
Swuehl , if possible could you please explain us how you did it.
Regards
john
Look at the Dim2 field event trigger actions in Settings - Document properties - Triggers.
Thanks Swuehl.