Newest 'qliksense' Questions - Stack Overflow

Questions tagged [qliksense]

Qlik Sense is a data analytics and visualization platform created and distributed by Qlik Corporation. The main aim of the platform is to allow users to self-discover the data that they require using fast in-memory analysis via a web portal.

0
votes
0answers
5 views

How to format a number in extension according to Qlik Formatting Pattern?

I'm just starting with my extensions development studies and have probably a dumb question: how to format a number I'm calculating inside my extension JavaScript code according to qlik formatting ...
0
votes
1answer
15 views

How can get I get relational data from another table and calculate the average in Qlikview?

I have relationship with 2 tables Table 1 - Process Table 2 - Process History Here the relationship is Id(Process table) and ProcessId(Process history table) I want to calculate the Average ...
-1
votes
0answers
6 views

Please suggest Qlik Nprinting version

Could you please suggest which version of Nprinting software we should go with. Hi, We are using Qliksense November 2018 patch 3 (version no 12.44.5). Now we have a requirement to publish Qliksense ...
1
vote
2answers
18 views

AVG of the last 7 days not returning results

I have an expression to give me the AVG of TIMETAKEN in the last 7 days but it isn't returning any results. =AVG({<STARTDATE={"<$(=date(today()-7))"} >}TIMETAKEN) I can get yesterdays AVG ...
0
votes
2answers
13 views

Date function on Field not working on a count

I have a Count which is giving me the following error: Error in set modifier expression The Expression is: =Count({<date(STARTTIMEDATE)={"$(=Date(Today()))"}>} IDID) STARTTIMEDATE is in ...
0
votes
0answers
8 views

Keeping lines that meet the condition in QlikSense script

I have a table where I just want to keep the rows where "Attribute 1" value is between the values of "Attribute 2" and "Attribute 3". I tried with a where clause but it doesn't seem to filter any ...
0
votes
2answers
135 views

Set title image in css

I am trying to set a title image using css within my custom theme. I know i can set a title image for an app manually but i want to do it within a theme using css. I have managed to set the ...
0
votes
1answer
19 views

QlikView Sort Expression MATCH with an IF expression inside

I am trying to create a custom sort expression using an IF statement. I have the following IF Expression: =IF(VOTA >= -15 AND VOTA <= 15, '0', IF(VOTA >= -60 AND VOTA <= -16, '-1 to 0', ...
0
votes
1answer
35 views

How can convert a field to uppercase in Qlikview and calculate the count based on the substring?

I want to convert a field values to upper case in qlikview My Query is SQL SELECT * FROM "mt_table"; My result table is as follows, I want to get the count of each Desc. For eg: I want to get the ...
-1
votes
1answer
9 views

QlikView Expression that ignores some selections and contains where explicit values

I have a basic expression SUM(value). I want to modify this expression so it does 2 things: Ignores all list box selections except one (yearperiod) and contains explicit where conditions. Pseudo ...
0
votes
1answer
23 views

QlikView Using an expression result as a selection or list box

I have a simple straight table that has a dimension and an expression. =If(Only({1}YOURFIELD) - Above(Only({1}YOURFIELD)) = 1, 'Match', 'Check') The expression either outputs Match or Check. ...
0
votes
1answer
7 views

QlikView Check if rows are continuous (1, 2, 3, 4, 5 etc) in a table

I have a Table box that contains a single field "Numb": Sample Data: Numb A1001 A1002 A1003 A1004 A1005 A1006 A1007 A1008 A1009 A1010 A1011 A1012 A1014 A1015 A1016 A1017 A1018 A1020 I want to have ...
0
votes
1answer
7 views

QlikView Default selection trigger - previous + current year minus current month

I want to create a sheet trigger to select the previous year and the current year but not the current month. If for example we were in 201604... Sample data is as follows: 201511 201512 201601 ...
0
votes
1answer
13 views

QlikView aggr more than one value excluded in list box

I have a list box that is powered by an expression to hide 1 value. =aggr(only({<[name]-={John}>}[name]),[name]) But i want to add a second name to this. I have tried... =aggr(only({<[name]...
0
votes
1answer
11 views

QlikView Using Accumulate 12 steps back for MAT graph, but cant limit date range

I have a line chart which has two dimensions: Yearperiod = 201601, 201602, 201603 etc Acgroup = FAB, BOB, TOE, QUE etc And one expression: SUM(Quantity) This also has Accumulate 12 steps back ...
0
votes
1answer
11 views

QlikView WHERE condition in chart calculated dimension

I have a chart with a calculated dimension it contains 4 possible values A, B, C, or D however in my bar chart i only want it to contain B and C I have tried: =MATCH(CATEGORY, 'B','C',) But this ...
1
vote
1answer
11 views

Qlikview use IN rather than = in a variable in an expression

I have a variable in an expression that SELECTS bottles. sum({$<[PCC] ={"$(=concat([MCC],'","'))"},[RCPT] ={'Bottle'}>}[Amount]*-1) I would like it to be able to select where RCPT equals ...
1
vote
1answer
8 views

QlikView expression for last 12 months & DISTINCT & not changed by selections

I have a few expressions: =COUNT(SUPP) Gives me 9316 which is correct as it is the total number. =COUNT(DISTINCT SUPP) Gives me 3429 which is correct as it is the total distinct number. =ROUND(...
0
votes
1answer
25 views

QlikSense Set analysis SUM expression with explicit less than and ignore selections

I have an expression in QlikSense: Sum({$<YEAR=,YEAR= {$(=YEAR(TODAY())-1)},MONTH={$(=NUM(Month(today()),'#'))}>}MOVES) Which gives me the SUM of MOVES from 2018 (previous year) in MONTH 6 (...
0
votes
1answer
24 views

Crack the expression

I am trying to understand expression in QV for the past few days and am unable to follow what it is trying to do especially the aggregate part with a nodistinct sum. I've tried to understand how ...
0
votes
0answers
14 views

How to display Qlik Sense Stream view in web app

I'm new to QlikSense. I have a simple requirement but not sure how to implement. We are building a custom web application. Upon user logging into the app (Use Windows Authentication), we would like ...
0
votes
1answer
16 views

How to reference a QlikSense sheet title in an expression

I'm currently using the 'Title expression' to add some dynamic abilities to my sheet titles. However, I would like to reference the actual sheet title in my expression. i.e. the Title that is ...
0
votes
1answer
22 views

Logic behind show/hide rows in charts

I am confused about the logic that exists behind the showing and hiding of rows in charts of QlikView/QLik Sense. Here is what I thought was the case: If, for some row, the value of a dimension is ...
0
votes
1answer
17 views

How to create custom themes in Anycharts Qlik extension

I am trying to create custom themes in our Anycharts Qlik sense extension. I used the following article as a guide, https://www.anychart.com/blog/2019/01/16/qlik-data-visualization-custom-drawing/ ...
3
votes
0answers
35 views

Unable to load table from “Select data from source” in Qlik sense

I use Data manager to update my Qlik app, due to some reason I am unable to load table through Select data from source feature. I can preview my table and edit or modify data in Data manager but ...
0
votes
1answer
36 views

Setup QABDI (Qlik Associative Big Data Index) on virtual machine

I am trying to setup QABDI on a virtual machine using the following: (1) kubectl (2) VirtualBox (3) Minikube (Sandbox version of Kubernetes) (4) Windows Server 2012R2 I have succesfully ...
0
votes
1answer
30 views

Cannot access Qliksense url from internet

I am new to Qliksense and Azure. We have installed Qliksense in Azure Virtual machine. Trying to access the Qliksense hub/QMC URL (https://xxx.intranet.myclient.com/hub) from the internet, but was ...
0
votes
0answers
15 views

How can I have the date just before the max/last Date and repeat the process on the whole table?

I'm trying to calculate the delta between two values in different dates : the firt is the date Max(COD) ( Sum({<COD={"$(=Max(COD))"}>*<Contrat={'PRESTA'}>} if([FMonth.autoCalendar.Num]&...
0
votes
0answers
21 views

how to edit or copy data loaded renames of my own published sheet/project in qliksense

This is the first time we decided to use QlikSense. So I am a newbie. I have developed a sheet for a table report. I loaded a lot of data and I made a lot of renames on the fields when they are loaded ...
0
votes
0answers
27 views

How can I get data from mongoDB object field and add group by based on that field?

Data in MongoDB SQL SELECT join_date, employee FROM "db".organization; result: [ { 'join_date': '2015-05-02', 'employee': { 'id': 1001122, 'name': 'XYZ', 'designation': 1} },{ 'join_date'...
1
vote
1answer
22 views

dual function not working when using several measures in a plot

I am making a barplot with two measures both using the dual() function like so: IF(AMOUNT>4,AMOUNT,dual(num('5','<#'),4)) I want the number formatting to be by measure expression so that all ...
0
votes
0answers
22 views

Expression in power BI

I have this expression which is in qlik sense syntax now i want to change / convert this into power bi dax syntax.. how i do that if([Curency] = 'USD', ((Sum({< Fiscal_Year = {'2016','2017'},[...
1
vote
1answer
8 views

Pivot table with each column having the previous columns value deducted from it

I have a pivot table with a dimension of 'companyname', column of 'month' and a measure of SUM(number_of_sales). I want to change the measure expression so each column shows the number of sales minus ...
1
vote
1answer
23 views

Null condition in qliksense expression

i have this expression sum( {<code={'12','13,'16','90'}, type={'abc','def','xyz'}, type2={'general'}>} net_pre) - sum( {<code={'12','13,'16','90'}, type={'abc','def','xyz'}, type2={'general'...
1
vote
1answer
24 views

Changing measure based on sheet

Is it possible to make a variable change in your measures based on the sheet that it is used in? I have in about 15 measures and 3 sheets. The 15 measures need to vary slightly from sheet to sheet, ...
0
votes
0answers
16 views

How to solve the error in QLikSense Dev Hub: Error “File modified by another user”

I'm getting this error repeatedly when trying to save a widget, so I can't save it. The widget doesn't contain anything unusual, only plain HTML and CSS. I'm unable to correlate it with some action, ...
0
votes
0answers
11 views

QlikSense Desktop V13 is not loading all the rows from an excel file

I'm using QlikSense (not QlikView) desktop version 13. I've a small excel table with 640 rows only. But QlikSense is loading roughly first 40-50 rows only and that too not in the sequence as they ...
0
votes
0answers
20 views

qlik ticket authentication TargetUri not set

Here is my code that I am using to do my qlik ticket authentication but when I use the address of the reverse proxy I don't get a TargetUri in the ticket response. I'm not really sure what I'm doing ...
0
votes
0answers
11 views

Drill Down dimensions in powerbi

I used qliksense. In that when we add multiple dimensions to make one like if there is fields Year, Month, Quarter then we add these like this Master items ----->Create new -----> then from here we ...
1
vote
1answer
38 views

Unable to delete Qlik Sense pivot table dimension column

I have a Qlik Sense pivot table dimension column that is missing the arrow on the right side. As such, I'm unable to delete it. Also, this column is titled "Values" and I have no such column in the ...
1
vote
1answer
53 views

How can I connect REST API (Java) from QlikView?

I want to connect REST API from QlikView and create chart/table view based on the JSON response from the REST call. Instead of connecting MySQL datasource and database Is it possible to connect REST ...
1
vote
2answers
31 views

How can we connect multiple data sources in QlikView?

I want to connect multiple data sources (Oracle, MySql etc) and databases. Then I want to create a table in Qlikview based on the result set of multiple select queries from the different databases. ...
0
votes
1answer
21 views

Export whole Qlik report with Qlik extension

im working on a Qlik extension inside the Qlik extension editor. My goal is to export the current report as pdf and excel. I tryed to select the html code, format it and save as pdf first. This ...
1
vote
1answer
37 views

Perform Incremental Load On Qlik Sense

New to Qlik Sense. I would like to perform incremental insert, update and delete. Through research i managed to write this script //This fetches deleted records SELECT `sale_detail_auto_id` FROM `...
1
vote
1answer
27 views

Less than or equal to date in set analysis

I am trying to sum values where the week number is less than or equal to the current week. It works if i just want equal to current week but not if i want less than or equal. This is what I've tried ...
0
votes
1answer
39 views

Expression in power bi and qliksense

I have 2 files one is in qliksense and other is in power bi .. both have same tables and relationships.. qliksense expression is if([Billing Doc. currency_WAERK] = 'USD', sum({<[Billing ...
1
vote
1answer
22 views

QLIK 101: I have a data/field with format DD/MM/YYYY. Need to creat bar chart with age range

First time I am using qlik sense. None of the videos that I have watch have help me so far. I have data/field name 'inscription' with date format dd/mm/yyyy. I need to set age range from 18y to 90y, ...
2
votes
1answer
26 views

Assign multiple string to a single variable

I have a button which when clicked assigns values to a variable which is used for filtering within other charts. It works fine when i only assign one value but when i try to assign 2 values to the ...
1
vote
1answer
16 views

Join filter panels as one

Need to add Filter panels as a vizualation and combine it as one
1
vote
2answers
35 views

Qlik Sense Set Analysis (A or B) and (C or D)

Trying to write a function to pull counts for Items sold in (Region A or Region B) AND (Region C or Region D). An intersection between these 2 sets count({<Item={'Region A', 'Region B'} * {'Region ...