Newest 'qlikview' Questions - Stack Overflow

Questions tagged [qlikview]

QlikView is a business intelligence 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 either a Microsoft Windows Application (QlikView Desktop) or via a web portal (QlikView Portal).

0
votes
0answers
5 views

Power Bi : if Condition with multiple cases specially with date = NULL or SYSDATE

i have a table with these columns shipped_date, Promise_date Example (consider that current date is today's date which is "20/6/2019"): Shipped_date Promise_date 20/1/2019 15/1/...
0
votes
1answer
33 views

Scrip execution goes on for infinite time in jenkins powershell plugin

I am able to execute powershell script on machine but not able to do it using jenkins powershell plugin My powershell script executes another program's UI (QlikView) and then closes it it works when ...
0
votes
0answers
8 views

Desvap with date fixed

I'm tried to make a distribution standard deviation in qlik sense with date fixed. IF((/*first condition */ /*count distribution */ stdev(TOTAL <variable,interval_variable> aggr((SUM(total ...
0
votes
1answer
17 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
7 views

QlikView Make button unclickable if no selections are made

I would like to be able to make my button unclickable / grayed out if no selections are made
-1
votes
1answer
8 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
0answers
48 views

How to fix 'Document failed to load' error after creation of xxx-prj folder for qlikview document

When I create xxxx.-prj folder for my xxxx.qvw and then open and save my xxxx.qvw it puts all the xml files in xxxx-prj folder. Buthen when I close xxxx.qvw file and reopen it, it gives me error ...
0
votes
1answer
12 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
9 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
24 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
11 views

How can I use a QLIkView set analysis expression in script?

I extend a QLikView application, that has two set analysis expressions used in the visualizations of the app. Now I need to assign the results of the expressions to a variabele but the problem is that ...
0
votes
1answer
18 views

QlikView error on nightly reload “Failed to open file in write mode for file”

I have a nightly re-load script that has been running successfully each night for months. Every so often I note in the morning that it has failed. The error is per question title: "Failed to open ...
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 ...
-1
votes
0answers
15 views

I need script that will allow me to search through my bank of receipts to find what the most popular “sold with” product is?

I have the following variables; Order ID, Product ID, Quantity of Product, Date, Price, Store ID I want to enter or select a product (x) from a list and for the resulting table to show me products (...
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
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'...
0
votes
0answers
18 views

Differences between Qlikview and SQL query results

I have Qlikview installed on my pc and it takes the data from a database. I want to write an sql query which would take the same data(for automatization). The problem is that my sql query returns ...
1
vote
1answer
51 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
30 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
26 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 ...
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 ...
0
votes
1answer
33 views

Using variable values in LOAD * INLINE Statement

I am trying to use variable values within a load inline statement but rather than the variable values being loaded im getting a weird substring of the variable formula. What i am doing wrong? So ...
2
votes
1answer
36 views

SQL Server, Qlik Sense naming convention

Is there any naming convention for Qlik Sense? I'm creating database in SQL Server which will be conected to Qlik Sense. I've noticed that some names are automatically changed. For exmaple I have ...
1
vote
0answers
12 views

Create custom button in Qlikview

Is there any possible way that I can create my own custom button? Something like creating a button in Photoshop with a specific extension and then using it inside Qlikview in a correct way, or a ...
1
vote
1answer
28 views

Macro to generate xlsx works fine manually but not from the batch through QlikviewManagement Consol

I am trying to export few charts to Excel (.Xlsx format) through Qlikview Macro and to save it on postrelaod at a particular location. The file works perfectly fine when it is run manually or from the ...
1
vote
1answer
47 views

Qlik Sense: how to specify path in Google Drive?

I have a Google drive account divided into some folders (say, Folder1, Folder2, etc.), with some subfolders in it. I successfully managed to connect my Qlik Sense app to it. I need to make it look for ...
1
vote
2answers
40 views

Stuck at Getting Survey Details from SurveyMonkey REST Connection in QlikSense

I'm trying to connect to the Survey Monkey API via a hard coded connection set in a variable but the connection is giving me such error: QVX_UNEXPECTED_END_OF_DATA: HTTP protocol error 400 (Bad ...
1
vote
1answer
29 views

Splitting the Filed Name (Table's Header) into Two Separate Lines

I have a dataset of the following structure: Company.ID DDR (25632) PTL (89567) 2512 89 74 9875 78 96 7892 14 73 I would like to split ...
0
votes
1answer
50 views

How can I delimit the width of a trendline?

I have these variables: X = (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16) Y = (1, 5, 4, 9, 7, 8, 12, 20, 9, 7, 4, 1, 1, 2, 1, 1) and I want to do a graphic with two visible partitions (X ...
0
votes
0answers
25 views

How to fix qlikview connection: Unexpected_end_of_data & file not found

I cannot connect my qlikview script. I get the two different errors. Unexpected_end_of_data (for the following two:) Product: SQL SELECT PRODUCT.product_number ...
0
votes
0answers
22 views

Qlikview : load daily multiple csv files

I have a daily file csv (named sales1 to salesXXX). my tasks is to load them. Secondly, another daily file csv (named vector1 to vectorYYY) Here the task is to link the 2 files (with a common field) ...
1
vote
1answer
27 views

QlikView add Calculated Dimension within a Table

Hi Guys I am trying to create a table in Qlikview that shows me sales starting from current week (Week 11) and works back Week 10 Week 9 etc to week 52 previous year. I can do this by creating ...
1
vote
1answer
17 views

List Box for Aged Inventory by Days

I want to filter my list box to where it only shows Items for 1-7 days, 8-14 days, a month and so on. How would I go about doing this? I am new to Qlikview but have some minor experience with coding ...
0
votes
0answers
21 views

How to get Username via Javascript in QlikView Extension?

I wanted to know how to get the OSUser() via Javascript in an extension object of QlikView. I have already tried it via Definition.xml file but it doesn't work like this. Can you help me fixing this?
0
votes
1answer
23 views

How do you differentiate between QVD source files and target files when reading a QVW's XML MetaData?

I am currently trying to find an alternative to the Governance Dashboard that Rob Wunderlich (Qlik founder) created, since I am currently encountering errors when using it. How do you differentiate ...
1
vote
1answer
114 views

How to create a stacked bar chart with multiple columns on Qlik

I am trying to create a stacked bar chart on Qlik from a dataset shown below. The chart should look like a picture below. (I apologize about the quality). I watched a couple of tutorials, but their ...
1
vote
1answer
24 views

Qlik View Google Map Extension Template error

I am new to the Qlik View tool. I have embedded an extension called Google Maps API v3. I have supplied the API Key in the configuration. But Still, when i select the longitude and latitude, it ...
1
vote
2answers
31 views

Connecting 3rd party reporting tools to MySQL

I have an application that runs on a MySQL database, the application is somewhat resource intensive on the DB. My client wants to connect Qlikview to this DB for reporting. I was wondering if ...
1
vote
1answer
28 views

Qlikview URL parameter selection not working due to cache

I am trying to embed a Qlikview chart in a custom webpage via an iframe - using singleobject.htm. I want to apply a certain filter so i am passing "&select=LB186,CSP" where LB186 is the listbox in ...
1
vote
1answer
31 views

Qlikview Format textbox expression as percentage to 3 decimal places

I am trying to show percentage increase / decrease based on week number for 2018 v 2019 with an expression in a textbox in Qlikview: Here is my expression: = num(Sum({<Year = {$(=Max(Year))}, ...
0
votes
1answer
21 views

Qlikview - Target missing where no actual value

I have a fact table of Delay by Date by Category (and many other Fields). I have another (target) table of DelayTarget by Month and Category. I am currently associating the target table to the fact ...