Stack Overflow
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.

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
0 answers

Reading data from QVD using python and databricks

I am new to python,can you help me with the details of how QVD can be read into azure databricks dataframe using python. I need the detail syntax (authentication with access key)of accessing the QVD from datalake and the read the same using…
Bala
  • 11
  • 1
1
vote
0 answers

How to index a specific column to perform field comparison calculations?

Given the following table: | A | B | holdingtemp1 | holdingTemp2 | holdingtemp3 | holdingTemp4 | idx | | Grits| 7:06:24 AM | 180.199 | - | - | - | 0 | | | 8:35:56 AM | - | 174.30 …
ericdwkim
  • 37
  • 5
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

Trying to implement nebula project is throwing an error: The splatting operator '@' cannot be used to reference variables in an expression

I am following the instructions on this page: https://qlik.dev/tutorials/build-a-chatbot-using-the-qlik-sense-natural-language-api I am actually getting an error which says the following: At line:1 char:5 npx @nebula.js/cli create mashup…
AOR
  • 11
  • 1
  • 7
1
vote
2 answers

Limit KPI by time range in set analysis using variables

I want to be able to limit a KPI, let's say turnover, to a specific time range which I chose by setting two variables: the lower bound and the upper bound. I have created two tables, which I derive from the calendar-table. month_start: LOAD…
Humpelstielzchen
  • 6,126
  • 3
  • 14
  • 34
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
0 answers

PostgreSQL SSL full or ca verification does not work

we are running a Windows Server 2019 with PostgreSQL. I want to use SSL so the connection between our database and another server within the domain is secure. I configured the postgresql.conf and pg_hba.conf and provided a .cert and .key file…
David Berger
  • 11
  • 2
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
2 answers

Number of Zeros after a non Zero number

Guys I have a business case where I need to count the number of Zeros after a non Zero number in a column with transaction values in qliksense. For example, 1,000 = 3 10,000 = 4 10,500 = 2 11,510 = 1 23,415 = 0 I have tried various codes but…
Shabeen Zarook
  • 61
  • 2
  • 8
1
vote
1 answer

How can I get the sheetname by passing the sheetid? QlikSense API

I have list of sheet ids in an app using the getAllInfos() method. I would like to find the sheet name. How can i get the sheet name?
gangata arun
  • 151
  • 2
  • 9
1
vote
1 answer

Qlik line chat expression

I have a table like this Month Customer Name Paid Collected Actual 1 John Smith 100 1000 10% 2 John Smith 200 1050 19% 3 John Smith 300 1100 27% 1 Kirk Polly 250 1150 22% 2 Kirk Polly 355 1200 30% 3 Kirk Polly 865 1250 69% The…
DATAMART
  • 29
  • 4
1
vote
0 answers

Qlik Desktop - Custom Connector - Error On ExtractQuery and other questions

I'm trying to develop a simple custom connector to Qlik, where I Get the data from a source specific, load the data in the Qlik and extract the data according own query. However, I found some problems and question, that I describe bellow: I pass…
Joao Pedro
  • 11
  • 4
1
vote
1 answer

Get a list of Default Bookmarks

Is there a way to get the default bookmarks with capability APIs? I tried app.getList('BookmarkList') method, but it doesn't return any parameter identifying that it's a default bookmark.
Ryan Arpe
  • 38
  • 4
1
vote
1 answer

in QLIK, how do I add data from table B to table A based on conditions in table A

still not completely understanding how to do certain things in qlik. I have a table payments, which includes a payment status, and a reference_key I have a table payment references which has a reference_key and a reference_number. payments has…
Darren Oakey
  • 2,894
  • 3
  • 29
  • 55
1 2 3
…
49 50