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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How can I get a specific selected field of a specific group?

Dear All,

I have two groups A and B, each group contain names of clients, and I want to make comparison between turnovers of clients.

I select Client1 from group A and Client2 from group B and I calculate every turnover for each client,

For that I made two variables which take the specific selected field:

vClient1 =GetFieldSelections( {GroupA} [Client1] )  ,

vClient2=GetFieldSelections( {Group B } [Client2] )

I must mention for every variable the group, but this does not work!

And   I want to show text box for each  value of client.


   Thanks in advance.

1 Reply
sunny_talwar

To use alternate state in GetFieldSelections() function... the syntax is this

=GetFieldSelections([Client1], False(), 'GroupA')

=GetFieldSelections([Client1], False(), 'GroupB')

Capture.PNG