topic Re: Qlik Sense Field Selection as Variable in App Development

Qlik Sense Field Selection as Variable

TKendrick20 — Wed, 06 Apr 2016 15:25:13 GMT

I have a field which has values that I would like to use as a Dimension in another chart. I was able to do this in QlikView, but I can't quite figure it out in Qlik Sense.

I am trying to create a variable where the value is equal to the selections in a field.

Then, I want to be able to use this variable as a Dimension in another chart.

What am I doing wrong? Or is the GetFieldSelections() not supported in the variable creator?

Re: Qlik Sense Field Selection as Variable

undergrinder — Wed, 06 Apr 2016 21:45:48 GMT

Hi Tim,

Try enclose the variable '' characters.

='$(vDemographic)'

It shows to Qlik Sense, that it contains a characters.

By the way I think this document will help you:

Makes Sense to go round in circles

Re: Qlik Sense Field Selection as Variable

TKendrick20 — Thu, 07 Apr 2016 13:13:48 GMT

Got it! I've added the '' as you said and had to add an = to the GetFieldSelections formula. I installed the extension you linked to, but did not end up using it.

The only problem now is if there are multiple selections in the Demographics field this will not work. Therefore, I am using the bi-listbox to limit the selections in the field to 1. Qlik Sense Listbox

Re: Qlik Sense Field Selection as Variable

undergrinder — Thu, 07 Apr 2016 13:24:17 GMT

Yes, the qsVariable extensions allows one selected button as I rembered, but why would you with one object to select multiple column?

I think you have dimensions like:

Age, Sex, School , and you would provide to users select which dimension is selected to show.

I missed/misunderstood something?

Re: Qlik Sense Field Selection as Variable

lightsection — Thu, 22 Aug 2019 13:47:36 GMT

In case of multiple selections it is better to use a string array to store selections in a variable.

Try this:

Concat(distinct [Demographics], ',')

This will store all selected values in a comma-separated string array. Which you can later pass into a set analysis condition if required.