Qliksense

[Anzhelika1]

good afternoon! please tell me how to make all the values ​​of the variable (there are more than a hundred of them) recorded in one field, for example Threshold-1
and in the application itself, I could select the value of this variable through the variable input and all formulas that have this Threshold-1 field were recalculated

[ajaykakkar93]

hi ,
if you want to filter the variable you can use set analysis to perform the action using variable input in 1 variable & reducing the numbers using set analysis 
create variable = vVariableName 
vVariableName value  =1
{<field={"$(vVariableName)"}>}

Value will look like 

{<field={"1">}

field will filter value 1 as if u have multiple u can add 


{<field={"$(vVariableName)"},field2={"$(vVariableName)"},field3={"$(vVariableName)"}>}

thanks

[rwunderlich]

=Concat(DISTINCT [Threshold-1], ',')

-Rob