Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jagannalla
Partner - Specialist III
Partner - Specialist III

Store possible value into variable in single button action

Hi,

Please find the attachement. I had selected Year value from Year field, now I've a possbiel values for A field. When I click on store button I want to store all possible values of A field in one variable.

I tried couple of steps but it is not working.

It is little bit urgent for me.


Thanks,

Jagan

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

Hi,

Instead of GetCurrentSelections() use

=Concat(DISTINCT A, '|')

Hope this helps you.

Regards,

Jagan.

View solution in original post

5 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

Instead of GetCurrentSelections() use

=Concat(DISTINCT A, '|')

Hope this helps you.

Regards,

Jagan.

CELAMBARASAN
Partner - Champion
Partner - Champion

Jagan is correct.

GetCurrentSelections will retrieve only selections you made.

Concat will retrieve all possible values of a field if you didn't made selection also.

jagannalla
Partner - Specialist III
Partner - Specialist III
Author

Thanks for your reply. But it is not working in button action for below scenario.

Please find the attached file.

- Select 2013 from year field, now we have only possible value for A field is A1.Now click on Select button, it needs to clear the entire application and it needs to select only A1 from A.

- Now select 2012 from year field and click on select button. It needs to clear and select possible values of A.

jagannalla
Partner - Specialist III
Partner - Specialist III
Author

Thanks for your reply. But it is not working in button action for below scenario.

Please find the attached file.

- Select 2013 from year field, now we have only possible value for A field is A1.Now click on Select button, it needs to clear the entire application and it needs to select only A1 from A.

- Now select 2012 from year field and click on select button. It needs to clear and select possible values of A.

jagan
Luminary Alumni
Luminary Alumni

Hi,

Please find attached URL

http://community.qlik.com/ideas/1424#comment-1885

Regards,

Jagan.