Skip to content

Instantly share code, notes, and snippets.

View hurrifan1's full-sized avatar
🌇

Austin Spivey hurrifan1

🌇
12 followers · 37 following
View GitHub Profile
@hurrifan1
hurrifan1 / apis.qvs
Created October 4, 2021 17:46
APIs in Qlik Sense
/* Working with API tokens in Qlik script */
// =====================================================================================================
// GET NEW TOKEN
// =====================================================================================================
SUB GetGraphToken
LIB CONNECT TO 'Azure - Microsoft Graph API - AUTH';
RestConnectorMasterTable:
SQL SELECT
@hurrifan1
hurrifan1 / Master Qlik Script Template.qvs
Created April 30, 2021 17:34
Master Qlik Script Template
/* Master script template! */
// ===============================================
// MAPPING
// ===============================================
[mapping]:
Mapping LOAD * Inline [
old, new
@hurrifan1
hurrifan1 / Stop-Start Qlik Services with PowerShell.ps1
Created April 27, 2021 20:24
Stop/Start Qlik Services with PowerShell
<# Start/Stop Qlik services in correct order:
1. Qlik Sense Repository Database (QRD)
2. Qlik Sense logging service
3. Qlik Sense Service Dispatcher (QSD)
4. Qlik Sense Repository Service (QRS)
...and in no particular order...
5. Qlik Sense Proxy Service (QPS)
6. Qlik Sense Engine Service (QES)
7. Qlik Sense Scheduler Service (QSS)
8. Qlik Sense Printing Service (QPR)
@hurrifan1
hurrifan1 / ArchiveUnusedApps.ps1
Created March 5, 2021 16:59
A PowerShell script using Qlik Windows CLI that allows you to archive unused Qlik Sense apps
<# Archive unused apps
# - Reference: https://github.com/ahaydon/Qlik-Cli-Windows
#>
# Connect to Qlik environment with Windows auth (current user) rather than a cert
Connect-Qlik -computername "hostname" -UseDefaultCredentials -TrustAllCerts
# Folder location for storing archived apps
$fldr = "C:\Users\folder\to\store\exported\QVFs"
@hurrifan1
hurrifan1 / QlikCSS.css
Created September 17, 2020 14:45
CSS in Qlik themes
/* Change the background color for a specific Multi KPI */
div[tid="Object ID"] div {
background-color: transparent!important;
}
@hurrifan1
hurrifan1 / Qlik script - Base64.qvs
Last active April 7, 2021 15:01
Qlik subroutine for encoding a string to Base64
Let string = '"' & 'String goes here!' & '"';
// ####################################################################
SUB Base64Encode (string)
Let vbase_String = '$(string)';
Let vbase_Base64Chars = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/';
Let vbase_QuotePad = 1;
@hurrifan1
hurrifan1 / main.dart
Last active July 19, 2020 20:22
This is a Dart script that generates a random alphanumeric string of variable length.
import 'dart:core';
import 'dart:math';
String getRandString(len) {
// Initialization of the string
var a = '';
// Generate a list of UTF-16 code units that
// are limited to just numbers and uppercase letters.
// Thus, we filter out the code units for non-alphanumeric
// characters (58:64, inclusive).
@hurrifan1
hurrifan1 / index.html
Last active February 1, 2019 15:31
ios logo shite new one
<svg
xmlns:dc="http://purl.org/dc/elements/1.1/"
xmlns:cc="http://creativecommons.org/ns#"
xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
xmlns:svg="http://www.w3.org/2000/svg"
xmlns="http://www.w3.org/2000/svg"
id="svg8"
version="1.1"
viewBox="130 130 100 100"