Qlik expressions are defined in the Expression Editor.
Questions tagged [qlik-expression]
96 questions
5
votes
2 answers
Difficulties in installing Qlik Catalog related SW
I am installing Qlik Catalog SW on Linux Read Hat Enterprise 7.9 following the instructions of the installation guide.
I have got the first problem in Tomcat Installation. Basically, I am not able to connect to Tomcat with the browser.
Below is a…
user17157716
2
votes
0 answers
Qlik (view or sense) filter display data (X-axis) on a chart when using server-side extension
Hello Qlik experts!
We have a unique challenge that we are trying to solve. We have a chart in our QlikView app that is displaying dates on the X-Axis and some measurements on the Y-Axis. Please look at the attached screenshot of the chart. The…
wntrsux
- 123
- 1
- 1
- 4
1
vote
2 answers
Qlik Sense: Understanding what this summation expression does
I'm very new to qlik sense - I have some database experience.
A team mate of mine recently quit who was the main owner of this piece of code.
num(sum({1<[report_date] = {"=$(=(date((currDate))))"}>
+1<[report_date]={"=$(date(currDate) - 7)"}>
…
BlendinBlandin
- 23
- 5
1
vote
1 answer
Problem with Data in Qlik Expression Editor - Want data after a specific date
I am trying to fetch Data i.e. Booking Data after a specific Booking Date and filtering with 3 order statuses by writing the below code in the Expression Editor
Count({
RajatK350
- 71
- 8
1
vote
1 answer
Uploading/Publishing Qlik Objects to Hub through Enigma.JS
I am currently trying to figure out a way to publish objects (charts/tables/variables/dimensions/etc) to the Qlik Hub from an application. I've been using Javascript, Enigma.js, and have been hosting the application on the same machine as the Qlik…
Matt K
- 11
- 2
1
vote
1 answer
Join leaf nodes with respective parent nodes in qlikview
So I managed to get two node tables in which in one of them, I have the "tree" or structure of the nodes, and in the other table I have the last nodes of that table (Leaf nodes).
I would like to make a full table where I have in Column 1, the…
Diego
- 11
- 3
1
vote
1 answer
Expression selection return the expression word not the whole row
I want to ignore the selection of a certain dimension in one expression, but still want that the table to be filtered for that dimension.
Following example
ID Project Project Lead
1 Dog Josh; Marc
2 Cat Sophie; Julian
So when I…
user17156214
1
vote
1 answer
Array Pair Loading from databases using Qlik Sense
Does anyone has experience how to load/prepare data:
[(1, 'a'), (2, 'b'), (3, 'c'), (4, 'd')]
taken from SQL database (stored there as value) into qlik sense table:
ID, Value
1, a
2, b
3, v
4, d
user17155772
1
vote
1 answer
How to get percentage Difference in qliksense
I need one help.
I calculate a Difference Between Current Year Sale and Last Year
like.
num(Sum({$<[HSUBSEGM.descr]={"Clinker and Cement"},
[CALYEAR]={">=$(vCurrentYear)"}>}[_volume_SO]),'##.0')- num(Sum({$<[HSUBSEGM.descr]
={"Clinker…
user17145460
1
vote
1 answer
Populating missing values in qlikview
I'm trying to populate missing values of the dates in between with peek function. I'm used the following code but still I couldn't get the results I'm looking for
Table:
LOAD * INLINE [
Date, Article, Quantity
01/02/2021, A, 10
…
walid
- 13
- 2
1
vote
1 answer
Qlik Sense Sum of One field based on unique value of other fields
Sample Data:
P Q R
1 A 3
1 A 3
1 A 2
1 B 5
1 C 7
2 A 3
2 A 3
Expected Output:
P Q R
1 A 5
1 B 5
1 C 7
2 A 3
i Have tried this Sum (Distinct R)…
Nandan
- 91
- 8
1
vote
2 answers
Qlik Sense Script sekecting data based of a specific criteria
Sorry if I am missing something obvious as I am trying to learn Qlik Sense.
I have a table with about 1 mil rows, I want to filter the data based the criteria below:
Find the 1st Lost Charges for the serial
Now switch the search to the serial +…
DDoze
- 53
- 2
- 9
1
vote
1 answer
How to filter with set analysis, sum and max, year and day
I'm trying to show the mount from last day loaded in the database (Filtering by year and date).
It will be like this:
Sum({$}[SH_historico_1.MONTO]/1000000)
The "19" have to be with code…
Sebastián
- 437
- 5
- 19
1
vote
1 answer
QlikSense Script Issue : I'm getting multiple records for some Casenumbers with different state like " Progress' & "On Hold"
LOAD
number as [Case Number],
number as key_case,
short_description as Description,
ApplyMap('map_CustomerDeliveryGroup',dv_company,'N/A') as CustomerGroupNo,
mid(dv_priority,5) as Priority,
dv_business_service as…
Aseem Sharma
- 31
- 3
1
vote
1 answer
How to group options in Filter Panel on Qlik Sense
I'm wondering how to group some values in a filter panel in Qlik Sense
For Example:
In a filter pane we have:
Item1
Item2
Item3
Item4
But Item3 and Item4 I want to group it just into a 1 ItemX2
So finally it will be:
Item1
Item2
ItemX2
How can I…
Sebastián
- 437
- 5
- 19