Current selection box limit setting

[#1]

Hi All,

I am exporting my current selections to excel and these selected values can be many in number. I have increased the 'maximum value in current selction' text box in Setting->User Preferences. But this setting is working only for my system , when my qvw file is published at server the value is limited to '6' as it was previously. As a result if more than 6 values are selected, current selection box shows '6 of 92'.

Can anybody guide me if I can update this setting at server , if yes then what/where is the option?

Please let me know if there are alternate solutions to export my large number of selections to excel.

Thanks and Regards,

Kirti Kakkar

[erichshiino]

Hi,

Maybe you can put this expression in a textbox and export it instead of the standand object 'Current Selections' :

=getcurrentselections (chr(13), '=', ';', 10000 )

Hope it helps,

Erich

[ivan_will]

"Can anybody guide me if I can update this setting at server , if yes then what/where is the option?"

Any idea?

[ivan_will]

Go to - C:\Users\All Users\QlikTech\QlikViewServer

Edit file - Settings.ini

Add before [Authentication] the following:

SelectionStampInBIFFExport=1

MaxCurSelEntries=1000