In one of my previous posts I explained how to enable the automatic integration of current selections within the Excel-export of QlikView Desktop or QlikView IE-Plugin.
I received a lot of eMails how to force this for the Ajax-Client and/or Mobile-Client, here’s the answer:
Setup for QlikView Server
Open the settings.ini file for your QlikView Server.
This file is located at
- Windows Server 2008
- Windows Server 2003
C:\Documents and Settings\All Users\Application Data\QlikTech\QlikViewServer\
Within the section [Settings 7] add the following line (doesn’t matter where):
Now for all data sent to Excel this will result into: