topic Re: Current selection box limit setting in QlikView

Current selection box limit setting

Tue, 07 Aug 2012 11:34:47 GMT

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

Re: Current selection box limit setting

erichshiino — Tue, 07 Aug 2012 16:55:48 GMT

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

Re: Current selection box limit setting

ivan_will — Fri, 26 Oct 2012 08:35:06 GMT

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

Any idea?

Re: Current selection box limit setting

ivan_will — Fri, 26 Oct 2012 09:05:13 GMT

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

Edit file - Settings.ini

Add before [Authentication] the following:

SelectionStampInBIFFExport=1

MaxCurSelEntries=1000