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.

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.

Qlik Sense is QlikView's data visualization tool used to inspire self service BI by its end users through a user friendly interface sitting on top of an already defined data structure.

747 questions
1
vote
1 answer

how do I create a qliksense app with multiple paramaterised instances

I'm brand new to qlik. I've been handed over a very complicated application with a lot of business logic that is constantly changing that can run against three different databases - ie dev/test/prod. Basically to decide which one it runs…
Darren Oakey
  • 2,894
  • 3
  • 29
  • 55
1
vote
2 answers

How to filter and extract data from Qlik Sense JSON-RPC API

I have successfully been able to connect to the Qlik Sense JSON-RPC API (QIX) using websockets. And I'm able to see all of the tables, fields, and table data. The tables have millions of rows and querying through all of the data takes hours. I…
chrislondon
  • 12,487
  • 5
  • 26
  • 65
1
vote
1 answer

Qlikview aggregation

I have a table like the below. For each date there is a have a product. And I want to aggregate by the product and carry forward the total. But the total is limited to 0. For each day and product, I want to aggregate and carry forward the…
JonJon
  • 41
  • 4
1
vote
4 answers

Convert Qlikview Hex Date to Normal Date

I exported a XML file from Qlikview and the dates are in this 16-letter/digits form (i.e. 40E5A40D641FDB97). I have tried multiple ways to convert it to floating decimals and then dates but all methods have failed (incl. Excel HEX2DEC). Anyone has…
1
vote
1 answer

Azure Synapse Pipeline-Execute an executable on a onpremise server

We are using Azure Synapse Pipelines for our ETL. At the end of the pipeline we need to call an executable in order to refresh the Qliksense dashboards. The executable and the Qliksense servers reside on on-premise servers.(Operating systems are…
new_user
  • 45
  • 3
1
vote
1 answer

How to calculate tables with percentages

I am having trouble creating a table in qliksense expressed in percentages. My raw data are like the following: raw data: I want to create a table that shows the number of new people per year among the different ages, both in absolute values and in…
1
vote
1 answer

FETCH the latest partition from HIVE table

Hi I am very much new to this. I have three columns YEAR, MONTH,DAY in INTEGER format. I want to load the script and combine YEAR,MONTH,DAY as single column and fetch the maximum. I tried like, Load year,month,date from HIVE.`abc`.`abc1'; SELECT…
jai chu
  • 45
  • 1
  • 7
1
vote
1 answer

Qlikview line chart

I have a table that looks like this Month Product Expected Actual Name 1 abc 10% 3% a 1 abc 10% 4% b 1 abc 10% 1% c 1 abc 10% 4% d 2 abc 20% 7% a 2 abc 20% 9% b 2 abc 20% 14% c 2 abc 20% 19% d I want to create a line chart…
DATAMART
  • 29
  • 4
1
vote
0 answers

Align tooltip with mouse move when hovering over segments in stacked bar plot [Qlik Sense Extension]

I am using Qlik Sense Cloud and I have successfully created a stacked bar plot using d3.js v4 framework. The chart looks like: As you can notice the tooltip is not correctly placed on the blue segment of USA (its wrong placed on white space above…
NikSp
  • 1,262
  • 2
  • 19
  • 42
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

Qliksense how works webapp?

Anybody knows how do I use Webapp in QlikSense? mashup is equal Webapp? I ve looking for this solution but I did not found it. What is the best mode to resolve?
1
vote
2 answers

Is there any way to import the Google Play Console Install Report by REST API?

I am looking for ways to import the report by REST API (with signed URL) to Qlik Sense but no clues. On the other hand, I have tried to use Data Transfer to BigQuery. It costs a lot as each install report of an app costs. (Trying to find a way that…
nicccholas
  • 13
  • 2
1
vote
1 answer

Rest API Where clause

I'm trying to query from Rest API through Qlik sense. How to apply where condition to the rest API call. Any answers appreciated. Thank you in advance.
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
1 answer

Is there any way to change label names in Qlik Sense?

So I have a table with two columns: location name and coordinates. I created a map visualization using the coordinates and, of course, the labels on the side menu are the coordinates (as you can see in the pic below). Is there any way to change…
user14061418