Sort values on a list

PHOTO

Fri May 19 2023 15:37:48 GMT+0000 (Coordinated Universal Time)

Saved by @jmbenedetto #qlik

Match(FieldName, 'Value1','Value11', 'Value111', 'Value1111')

To be use on Graph

Save snippets that work from anywhere online with our extensions

Available in the Chrome Web Store

Get Firefox Add-on

Get VS Code extension

Comments

More like this

Qlik Sense

@jmbenedetto

Load a limited number of lines from file into Qlik Script Read files within a given range Create inline table Iterate over a table in QS Transform csv file into QVD Copy/rename files Scramble the values of a column by replacing them with other values from the same domain Create a table using values on a variable Create a table with all files respecting the name pattern Developer mode in Qlik Sense SaaS Define URL to call Qlik Automation Sort values on a list

Calculating field percentage in Qlik

sum(myNumber)/sum(total{1} myNumber)

Load a limited number of lines from file into Qlik Script

[memory_table_name]:
First 100 Load
     *
From [data_file.qvd](qvd);

Read files within a given range

FOR period = 10001 TO 10101
                IF NOT ISNULL(QVDCREATETIME('lib://PATH\FILE$(period).qvd')) THEN

Table:
LOAD
*,
FROM [lib://PATH\FILE$(period).qvd]
(qvd);
END IF
NEXT;
;

Define URL to call Qlik Automation

LET vAutomationURL='$(vBaseAutoURL)$(vAutomationID)/actions/execute?X-Execution-Token=$(vAutomationToken)&application=&'& DocumentName()

Sort values on a list

Match(FieldName, 'Value1','Value11', 'Value111', 'Value1111')

Browse more snippets >>