Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Getfieldselections in alternate state table

Hi,

I've set a table to alternate state and want to get in that table the selections from a mainstate table. I've tried the following formulas. But they don't work.

GetFieldSelections([Field],',',100000)

GetFieldSelections([Main State]::[Field],',',100000)

GetFieldSelections([Field],',',100000,'Main State')

Concat([Field],',')

Concat([Main State]::[Field],',')

Concat([Field],',','Main State')

If I set the selection box also to an alternate state like "State A". The following formula works.

GetFieldSelections([Field],',',100000,'State A')

So it only doesn't work with main state.

Could you please help me with it?

Thanks a lot in advance.

4 Replies
sunny_talwar

When you say main, do you mean default or inherited state? May be try this:

GetFieldSelections([Field],',',100000,'$')

vinieme12
Champion III
Champion III

We don't need to specify a state for the default state just use

=GetfieldSelections(Fieldname)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
sunny_talwar

I thought so too, but it seems that this did not work for him

GetFieldSelections([Field],',',100000)

So, might make sense to include the state

GetFieldSelections([Field],',',100000,'$')

sunny_talwar

Here is a sample attached

Capture.PNG