Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
vipingarg23
Creator
Creator

getfieldselection with alternate statesq

I have two same listboxes (one is clone to another) with different alternate states as StateA  and StateB

Value
2
3
4
5

Value
2
3
4
5

I need to get the data where value between whatever selection made by user from both listboxes. For example: if user selects 2 from first listbox and 4 from second listbox then I need to get the value between 2 and 4. How should I implement this?

What I am thinking, If I get the selection value from both listboxes through getfieldselections() and then apply the set analysis. But As far as I know getfieldselection() doesn't work with alternate states. Can anybody suggest on the same or any other alternate solution to solve the same?

1 Solution

Accepted Solutions
vishsaggi
Champion III
Champion III

Use like store the selection states in two variables like

Create two alt states using Ctrl+Alt+D General tab. you know this i believe.

In below and are the two alternate states i created change the names accordingly.

Ctrl+Alt+V will open variable over view and i created vStateA and vStateB then added this in to these variables

= Only({} Value)

= Only({} Value)

View solution in original post

7 Replies
sunny_talwar

Look at Stefan's response here:

https://community.qlik.com/thread/85080#800669

vishsaggi
Champion III
Champion III

Use like store the selection states in two variables like

Create two alt states using Ctrl+Alt+D General tab. you know this i believe.

In below and are the two alternate states i created change the names accordingly.

Ctrl+Alt+V will open variable over view and i created vStateA and vStateB then added this in to these variables

= Only({} Value)

= Only({} Value)

vipingarg23
Creator
Creator
Author

I see this post earlier also but this is also not working for me

On Tue, Aug 29, 2017 at 10:35 PM, Sunny Talwar <qcwebmaster@qlikview.com>

sunny_talwar

Are you using QV11.2 SR7 or below?

vishsaggi
Champion III
Champion III

Can you explain a little more your actual requirement with some sample output?

vipingarg23
Creator
Creator
Author

I am using QV12

vipingarg23
Creator
Creator
Author

Great Vishwarath...It is working fine..Thanks a lot Vishwarath and sunny for your help.