topic Getting Current Selection in Checkboxes in QlikView

Getting Current Selection in Checkboxes

Anonymous — Tue, 05 May 2015 21:59:29 GMT

Hello Everyone,

there is a question:

iI have a requirement where the title of a chart should be depending on the filter selection of the user and only what the user wants to see in the title.

So if the user selects:

Filter A, Filter B and Filter Z the user should be able to say which filter (can be more than one) should be displayed in the chart as a title.

My question is now:

Is it possible to get somehow the current selected filters (so what we have in the current selection box) to be shown in checkboxes?

Then I'd tell the users to check the boxes of those values, that he wants to see in the chart as a title.

So if the user A select Filter A and Filter B, then the title would be Value of Filter A and Value of Filter B

If user B is only interested in Filter Z, the user checks Filter Z and only the value of Filter Z will be shown in the report.

Any ideas?

Re: Getting Current Selection in Checkboxes

prieper — Tue, 05 May 2015 22:16:09 GMT

You may use the function GETCURRENTSELECTIONS as a starter. This function give the currently selected values in a (concatenated) string. This string can be analysed for certain keywords and converted into the desired title.

Edith says: GETFIELDSELECTIONS would work on specific fields

HTH Peter

Re: Getting Current Selection in Checkboxes

ramoncova06 — Tue, 05 May 2015 22:16:20 GMT

I am assuming something like in the following post ?

Dynamic Tables - An alternative approach to CONCAT using BIT operators