Qlik Sense Field Selection as Variable

[TKendrick20]

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?

[undergrinder · Accepted solution]

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

G.

[TKendrick20]

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

[undergrinder]

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?

G.

[lightsection]

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.