topic Re: GetCurrentSelection for Alternate State in QlikView

GetCurrentSelection for Alternate State

tresB — Thu, 20 Jun 2013 06:13:20 GMT

Is there any way to get the selections for alternate states? Copy Alternate State in trigger would not work for me, because i have to get the string in a variable.

Thanks.

Re: GetCurrentSelection for Alternate State

Thu, 20 Jun 2013 06:20:28 GMT

see link

http://community.qlik.com/message/355032

http://community.qlik.com/ideas/2340

Re: GetCurrentSelection for Alternate State

tresB — Thu, 20 Jun 2013 07:00:21 GMT

Hi,

Thanks for your reply, however your first link is not about getting the selection string, and the second link seems not exist.

Update: Please note that i don't want to use the concat function along with DISTINCT keyword. If any direct way is there, please suggest.

Re: GetCurrentSelection for Alternate State

Thu, 20 Jun 2013 07:08:35 GMT

see link

http://community.qlik.com/ideas/2340

It would be very helpful If there is a alternate state to be specified in this functions to get the selections and counts for the each alternative state.

It will be useful in checking the selections of the multiple alternate states in single object.

May be like this

GetCurrentSelections(<AlternateState1> FieldName),GetSelectedCount(<AlternateState2> FieldName)

Re: GetCurrentSelection for Alternate State

tresB — Thu, 20 Jun 2013 07:17:38 GMT

GetCurrentSelections and such functions do not allow set analysis. And as i mentioned earlier i am looking for alternative solution to CONCAT function.

Anyway, thanks for your responses.

Re: GetCurrentSelection for Alternate State

Fri, 21 Jun 2013 05:24:30 GMT

Hey Tresesco,

Why not to use the the variable in your set analysis and then use the system function...

Regards,

Nitin Jain

Re: GetCurrentSelection for Alternate State

cspencer3 — Fri, 30 Jan 2015 19:17:39 GMT

I know this is a bit late but the GetFieldSelections() function will take a state name as an argument. The arguments go in order of: FieldName, ValueSeparator, MaxValuesReturned, StateName. Thus to get a list of field selections (or just one) from the state State1, separated by semicolons you would do: GetFieldSelections(FieldName, ';', 1, 'State1') and it will return what you need.

Re: GetCurrentSelection for Alternate State

Anonymous — Fri, 30 Jan 2015 20:04:21 GMT

Charles is right!

You can also see the last reply of this post:

http://community.qlik.com/message/688334#688334

Elena

Re: GetCurrentSelection for Alternate State

tresB — Wed, 14 Oct 2015 10:12:57 GMT

Yes, your being late only makes this true. That is, QlikView 11 SR8 and newer versions have state argument. When I wrote this thread, SR8 was not there in existence. However, it's good that we have it now.

Re: GetCurrentSelection for Alternate State

cspencer3 — Thu, 15 Oct 2015 19:34:15 GMT

Better late than never, they say!