Changing QV default selection color without Document Extensions

Settings.ini is setting file for QlikView, it is available for both desktop and server in below respective locations. We need to add couple of lines on this file for overriding the default Selection colors. This file is frequently edited for enabling SSL and creating PGO file as XML.

QlikView Desktop (Close QV desktop before editing Settings.ini)
C;\Users\User_Name\AppData\Roaming\QlikTech\QlikView
QlikView Server  (Restart QV service after editing Settings.ini)
C:\ProgramData\QlikTech\QlikViewServer

Below lines need to be added in Settings.ini file. Here CustSelBgColors1 is used for selected values and CustSelBgColors2 for relevant/related values on different fields.
[Settings 7]
CustSelBgColors1=7777777
CustSelBgColors2=9999999

Finally to apply the new color scheme Open the application and set custom color.
Document Properties -> General -> Selection Appearance -> Color Scheme -> [Custom]

Qlik Sense Mashup

Got couple of ideas for IFrame alternatives (wordpress.com doesn’t support IFrame tag) so tried to embed below charts but with no luck.

https://charts.qlikcloud.com/5620287d4452494a4447d51d/chart.html
https://charts.qlikcloud.com/56217e501315369e22475c2a/chart.html

P.S. Above two charts are from dashboard hosted publicly on my Qlikcloud.com account.

Triggering task on QMC upon file arrival

Basically it’s two step process:

1. Creating batch file &
2. Creating ‘External Program’ task on QMC

Taking bottom-up approach for easier understanding/explanation sake.

2. Batch command template and example (used here):

“Batch_File_Path” “Sharepath_to_poll_with_file_format” Idle_time Time_limit_for_polling

“D:\QlikView\QlikView Source Documents\batch\FilePolling.bat” “\\Sharepath\Token\*.txt” 600 20:00

Create ‘External Program’ task on QMC, use above batch template for ‘Command line statement’.

 

1. Batch File code:

REM REM is comment statement in batch file
REM Displaying values passed to the batch file
echo off
echo file_name %1
echo time_polling %2
echo end_time %3

REM Terminate if there are no parameters
if (%1) == () (exit /b 0)

REM This loop will break on two conditions 1. On seeing file 2. Upon time out
:Loop
If exist %1 (exit /b 0)
If %TIME: =0% GTR %3 (exit /b 1)
REM Timeout /T TIME >NUL is sytax. TIME is replaced by second parameter in this code. >NUL means 1>NUL default output 2>NUL default error output. Default output for this code is nothing.
Timeout /T %2 > NUL
Goto Loop