Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rbartley
Specialist II
Specialist II

QS Selection Object Threshold for Mashups "x of y" problem

Hello everyone,

Up until now, I have been working quite happily with the selection object to look at the current selections for a field.  However, I notice that when there are more than a certain number of values selected, instead of showing a comma-separated list of all of the selected values in qSelected, it shows a string of the format x of y, e.g. "10 of 40", where x represents the number of selected values and y is the total number of available values. 

I saw a post concerning Qlk View where the selection threshold was mentioned, so I tried :

value.qSelectionThreshold=10; (see below for context)

$.each(reply.qSelectionObject.qSelections, function(key, value)

{

  value.qSelectionThreshold=10;

  var field = value.qField;  //The field name

  if(field=="Latest Year Flag(Price)"||field=="Year (Price)")

  {

  strSelectedYears = value.qSelected; //The concatenated string of selected values

  } 

});

However, although I could see that the property of the value object seemed to have been altered, it did not seem to make any difference to the result.

Working if few values selected:

SelectionThreshold Few Values.PNG

Not working if 7 or more selected:

SelectionThreshold Many Values.PNG

Does anyone have any ideas?

1 Solution

Accepted Solutions
fede_muller
Contributor
Contributor

Hi Richard

I correct myself, it seems is possible to extend this threshold in QLik Sense Enterprise as well.

You need to modify the setting.ini file usually located in C:\ProgramData\Qlik\Sense\Engine

Under [Settings 7] section add below line:

MaxCurSelEntries=15

Remember to leave a blank line as the last line in the file otherwise the variable won't be captured

Restart the Qlik Sense Engine service and now you should be able to select up to 15 items.

View solution in original post

5 Replies
fede_muller
Contributor
Contributor

Hi Richard,

It seems in order to change the qSelectionThreshold value you will have to change a user setting which is something not possible at the moment. They said this functionality it's on the roadmap, but this was more than a year ago...

Check below thread:

Re: Sense extensions : How can I change qSelectionThreshold value ?

Cheers

Fede

fede_muller
Contributor
Contributor

Hi Richard

I correct myself, it seems is possible to extend this threshold in QLik Sense Enterprise as well.

You need to modify the setting.ini file usually located in C:\ProgramData\Qlik\Sense\Engine

Under [Settings 7] section add below line:

MaxCurSelEntries=15

Remember to leave a blank line as the last line in the file otherwise the variable won't be captured

Restart the Qlik Sense Engine service and now you should be able to select up to 15 items.

rbartley
Specialist II
Specialist II
Author

Thanks Federico.  That worked perfectly.

Digvijay_Singh

Thanks! I was also searching for how to do that.

Anonymous
Not applicable

Hi, Yes I read an old post where it is said that it is in the roadmap to add the threshold as parameter. Any update for this? We would like to put the limit higher just for an specific call.