Tools for Qlik

Text editor

Qlik
Qlik Community

1Notepad++

2018-09-20
Notepad++

Notepad++ is a free (as in "free speech" and also as in "free beer") source code editor and Notepad replacement that supports several languages. Running in the MS Windows environment, its use is governed by GPL License.

When used with Qlik language definition it can help be to be more productive with your scripts (for both Sense and View).

2Sublime Text

2018-09-20
Sublime Text

"A sophisticated text editor for code, markup and prose"

Can open really hudge text files : really helpfull when you have to edit a large source file (>1Go) for qlik (csv or txt)

Tools for Qlik

QVD Reader

Qlik
Qlik Community

1EasyMorph

2018-09-20
EasyMorph

"A powerful data transformation and automation tool. Optimized for business users. A free edition available."

2Q-Eye

2018-09-20
Q-Eye

"FREEWARE QVD AND QVX FILES EDITOR"

Tooltip

Javascript


Doing some stuff with SVG in HTML5...just some donuts using bootstrap, and jQuery
Available parameters :
  • Size
  • Color (donut and border colors)
  • Value !
Slider uses ajax call to load dynamically donuts : depending on your bandwith, animation can be slower than expected (but will work)


Loading...
Loading...
Loading...

Mondial Tornado 2005 - Soci�t� des R�gates Rochelaise

Tooltip

Windows Server 2012

Remote management from Windows 8.1 Server Manager (RSAT)
How to add a workgroup server to your client workgroup Server Manager (run on your client in an elevated prompt):
Set-Item wsman:\localhost\Client\TrustedHosts serverName -Concatenate -Force
Technet - Troubleshoot Manageability Status Errors in Server Manager
Tooltip

Qlik View

Qlik View
Qlik Community

1Conditional display of expression in straight table

Sometimes it can be usefull to hide/show a column in relationship with a selection made in another elements.

In order to do so, you can use conditional view

QlikViewEnable conditional

In my test case, i've defined one expression called Type with tow values possible (PROD and MAINT).
When applying following condition, column is displayed if value selected is PROD or if both values are selected.
=if(match(GetFieldSelections(Type),'PROD','MAINT, PROD'),1,0)

2Load most recent file in a folder based on its name

I needed to load the most recent file to load datas in a qlikview app.
My problem was that the most recent file was not based on date time of the file but based with the name of the file.
Goal is to load data and sort them desc and return only the first record, so i get the most recent file.

Sub DoDir (Root)
// filetype to search for in current directory, assuming files are excel type (.xls) For Each Ext In 'xls'
For Each File In FileList (Root & '\YOUR FOLDER NAME*.' & Ext)
Files:
Load '$(File)' as Name
//if you want to sort by file date time uncomment next line and adapt loop
//FileTime('$(File)') as FileTime,
RangeSum(Peek('FileCount'), 1) as FileCount
Autogenerate 1;
Next File
Next Ext
/*
// search in subdirectories, uncomment if needed (recursive loop) For Each Dir In DirList (Root & '\*')
Call DoDir (Dir)
Next Dir
*/
End Sub
//Call the fucntion DoDir with the path to the folder to be scanned
Call DoDir ('CHANGE TO YOUR FOLDER PATH THAT WILL BE SCANNED');
//load
MostRecentFileName:
FIRST 1 LOAD Name AS MostRecentFileName
RESIDENT Files
ORDER BY Name DESC;

LET vFileToLoad = FieldValue('MostRecentFileName', 1);

//load datas to be used in your QlikView app
LOAD * FROM $(vFileToLoad)(your source parameters);

Tooltip

Qlik Sense

Qlik Sense
Qlik Community

1Howto change default storage of Sense Apps with Qlik Sense Desktop

2018-09-20

Sometimes it can be usefull to store your qlik sense apps to another folder/drive (helpfull when space is short on main hard drive).

In order to do so, you have to edit settings.ini (located by default in C:\Users\YourUser\Documents\Qlik\Sense)
You have to add a new line as illustrated :

QlikViewEnable conditional