topic Re: Store possible value into variable in single button action in QlikView

Store possible value into variable in single button action

jagannalla — Tue, 23 Apr 2013 13:42:24 GMT

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

Re: Store possible value into variable in single button action

jagan — Tue, 23 Apr 2013 13:53:52 GMT

Hi,

Instead of GetCurrentSelections() use

=Concat(DISTINCT A, '|')

Hope this helps you.

Regards,

Jagan.

Re: Store possible value into variable in single button action

CELAMBARASAN — Tue, 23 Apr 2013 13:58:49 GMT

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.

Re: Store possible value into variable in single button action

jagannalla — Wed, 24 Apr 2013 14:08:43 GMT

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.

Re: Store possible value into variable in single button action

jagannalla — Wed, 24 Apr 2013 14:13:21 GMT

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.

Re: Store possible value into variable in single button action

jagan — Wed, 24 Apr 2013 15:16:07 GMT

Hi,

Please find attached URL

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

Regards,

Jagan.