{{ message }}

Instantly share code, notes, and snippets.

🏔️
Bringing DevOps to Qlik Sense - one tool at a time. Hello SenseOps!

# Göran Sander mountaindude

🏔️
Bringing DevOps to Qlik Sense - one tool at a time. Hello SenseOps!
Created Oct 16, 2015 — forked from nate-untiedt/wblGen.bat
A simple batch file that automatically generates the wblfolder.wbl for your Qlik Sense visualization extension.
View wblGen.bat
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode characters
 @echo off REM wblGen.bat - v 1.0.0 - 2015-10-09 REM Description: REM A simple batch file that automatically generates the wblfolder.wbl for your Qlik Sense visualization extension. REM REM Author: Nate Untiedt - Analytics8 - nuntiedt@analytics8.com REM REM Credit to: http://stackoverflow.com/a/8387078 setlocal EnableDelayedExpansion
Created Oct 11, 2015
Fastest way of finding max/min values of a field in Sense or QV
View sense_find_max_value_of_field
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode characters
 // The obvious way of finding the max/min value of a field might something like this: // // LOAD max(salesDate) Resident dataTable; // // However, if dataTable is very large (hundred of millions of lines or more, with many columns), the above will be // very slow, as we will end up traversing that entire table. // // Instead, the fastest method of achieving the desired result is to load the FieldValue()s. // We then only look at the values of the salesDate field itself, and not the entire dataTable table. // Performance gains by many orders of magnitude can be gained by using this method.
Created Oct 7, 2015
QlikView / Sense code mapping US states to regions and divisions
View sense_us_state_region_division.txt
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode characters
 // Load US high level regions (easter, southern, midwest etc) and divisions // From https://en.wikipedia.org/wiki/List_of_regions_of_the_United_States // Could also use https://www.npac.com/the-npac/about/npac-regions if more granularity is needed US_States: NoConcatenate Load [State code], [US census region], [US census division] Inline [ State code,US census region,US census division
Last active Oct 24, 2017
QlikView / Sense set expression to pick the data for the last available date
View sense_set_sum_per_max_date
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode characters
 // Sum FieldName per the last available date we have data for, withinin the current selection Sum( {$} FieldName) Last active Oct 11, 2015 General set analysis syntax View sense_set_general This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode characters  // General syntax for set analysis {$}
Last active Mar 26, 2020
QlikView / Qlik Sense code to create table with all QVDs to load later in a script