topic Re: Alternate states with getfieldselections in QlikView

Alternate states with getfieldselections

Fri, 21 Jun 2013 08:19:19 GMT

Hi ALL,

How can i use alternate state with getfieldselections? Please post an example or expression.

Re: Alternate states with getfieldselections

jagan — Fri, 21 Jun 2013 08:31:59 GMT

Hi,

Try like this

=Concat({[AlternateStateName]}DimensionName)

Regards,

Jagan.

Re: Alternate states with getfieldselections

Fri, 21 Jun 2013 08:47:08 GMT

Thanks for the reply Jagan. But right now this is showing all the values from that dimesnion concatenated and i just want to get only that value from the dimension which is selected.

How can i do that?

Re: Alternate states with getfieldselections

Fri, 21 Jun 2013 08:55:40 GMT

see link http://dailyqv.blogspot.in/2013_05_01_archive.html

Functions which won't support Alternative states and its work around

Functions which basically operate on current selection state like

GetFieldSelections, GetPossibleCount will not take parameter as Alternative states.

some thing like GetFieldSelections(<State1> Field1) is not possible in Qlikview 11.

Instead we can use general functions like Maxstring, Concat, Count functions.

For example if we want to know selection made in a field which has an alternative state and have 'Allways one selection'.

In this case for accessing the selection made in that field we can use.

maxstring({[State1]} [Field1]).

If allways one selections is disabled and for getting all selections we can use.

=concat({[State1]} distinct [Field1],'|')

For getting Selection count we can use.

=count({[State1]} distinct [Field1])

Re: Alternate states with getfieldselections

Fri, 21 Jun 2013 10:25:10 GMT

But the Maxstring is giving me the maximum value only, i want the currently selected field.

Re: Alternate states with getfieldselections

jagan — Fri, 21 Jun 2013 11:03:01 GMT

Hi,

Can you come up with an example? It helps in understanding the scenario.

Regards,

Jagan.

Re: Alternate states with getfieldselections

murozel76 — Thu, 01 Aug 2013 15:09:01 GMT

Thank you for this. I used the "maxstring" function for the very same purpose and it's ok.

Regards,

Re: Alternate states with getfieldselections

Anonymous — Thu, 18 Jun 2015 09:02:15 GMT

Excellent! Thank you.

Re: Alternate states with getfieldselections

swuehl — Thu, 18 Jun 2015 09:12:28 GMT

Just an update:

Since 11.20 SR8, these functions accept a third argument to define the state:

1.4.3 Alternate state parameter for certain functions

New parameter added to the functions “GetSelectedCount()”, “GetFieldSelections()” and

“GetCurrentSelections()” to query other states than the main state.

E.g. =GetFieldSelections(Quantity, ';', ,'StateA')

Re: Alternate states with getfieldselections

Anonymous — Thu, 18 Jun 2015 13:28:28 GMT

Oh Wow! Thanks for this. Much appreciated.

Re: Alternate states with getfieldselections

Anonymous — Thu, 18 Jun 2015 13:30:09 GMT

Thanks a mill. Much appreciate that.

I have SR7 - can I just down the latest version?

Re: Alternate states with getfieldselections

swuehl — Thu, 18 Jun 2015 13:33:41 GMT

Your are talking about the desktop client, right?

Yes, you should be able to download the latest QV 11.20 SR (12, I believe) fromt the Qlik download site.

If you are working in a company, might be advisable to check if there are any restrictions on downloading and using different QV versions.

Re: Alternate states with getfieldselections

Anonymous — Thu, 18 Jun 2015 14:21:45 GMT

Yes the desktop client.

I have a version on my own laptop but actually I remote into a client's

server, so they'd actually have to install it there.

Thanks for your help.

Re: Alternate states with getfieldselections

Anonymous — Fri, 31 Jul 2015 07:58:17 GMT

I'm having a different problem now with these alternate states and the drill down.

Because I have made the graph's state the default state to get the drill down to work, the filters on the sheet don't apply to my chart, which means I need to make all my list boxes part of the default state, which then basically means I'm not using an alternate state.

Can anyone help please? Is there a way to make sure the chart filters the data based on the sheet's alternate state and still have the drill downs working?

I am using this expression to make my dimension visible

=if(GetFieldSelections(DimGroup,';',10, 'GraphC') like '*Account*', true(), false())

Thanks

Re: Alternate states with getfieldselections

wonkymeister — Tue, 26 Jul 2016 07:55:09 GMT

Absolutely awesome - fixed my issue

=Concat({[AlternateStateName]}DimensionName)

Thank you