Store possible value into variable in single button action

[jagannalla]

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

[jagan · Accepted solution]

Hi,

Instead of GetCurrentSelections() use

=Concat(DISTINCT A, '|')

Hope this helps you.

Regards,

Jagan.

[CELAMBARASAN]

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]

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]

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]

Hi,

Please find attached URL

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

Regards,

Jagan.