Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I am trying to add or create new table which will include the concat of 2 existing columns from different tables. Below is the sceanrio
LIB CONNECT TO "Final_DB"
[Outbound]:
Load "address" as [Origin address]
From DB (query to call data)
[Inbound]
Load "address" as [Destination address]
From DB (query to call data)
How can I add or do Concat of both "Origin address - Destination Address"?
I want to create the key to map this with manual excel master data sheet.
Looking forward for your support !!
Sys overview:
# Windows Server 2022 Standard
# QS Enterprise on Windows - February 2024 and November 2023 (initiall releases)
This is what I get.
screen
I've attached the log from PostgreSQL 14:
# it seems that PostgreSQL 12.5 is installed fine
#... but PostgreSQL 14 failed for some reason ...
any ideas ?
I'm working on converting some reports from QlikView over to SSRS.
I'm looking for this calculation in particular (screenshot). I know that REMAINING_HOURS is not an actual column in the OPERATION table in the database and that there's a calculation being done to get REMAINING_HOURS. I can't find how it's being calculated though.
When I go to Edit Scripts... and look at the Operation tab, I don't see anything referencing REMAINING_HOURS.
I'll also say that Production Schedule is a report within this .qvw and that I'm also not a frequent or seasoned user of QlikView.
Could anyone point me towards where I can view how this field is being calculated?
Hello
I have problem with synth keys. Im trying to solve it by preparing key but it won't work.
Here's my data:
LOAD
ORDER_NO as PROD_ORDER_NO,
SEQ as QM_PROD_SK_SEQ,
TT_NO as PTT,
RESULTS1
RESULTS2
RESULTS3 ...
2nd table
ORDER_NO as PROD_ORDER_NO,
SEQ as QM_PROD_SK_SEQ,
TT_NO as PTT,
DIF_RESULTS1
DIF_RESULTS2
DIF_RESULTS3 ...
How to prepare a key which will connect PTT and PROD_ORDER_NO without syth key, so that i will still be able to use PTT or PROD_ORDER_NO filter?
Hello , help with a code for tornado chart , its giving me negatives for one gender
if([GENDER]='F',
Num(count(if(YEAR([TRANSACTION_DATE])=vCY AND COUNTRY='INDIA', ID))*-1),
Num(count(if(YEAR([TRANSACTION_DATE])=vCY AND COUNTRY='INDIA', ID)))
)
my graph is this
In addition , how do i color with own colors for F and M , the below is the code am using but its not workingif([GENDER]='F', '#000000','#C51633')
Hello
I need some help 😉
I have dimension AA with values 'one' and 'two'
I have another dimension BB with values 'red' and 'green'
I have several variables:
one_red = 1, one_green=2, two_red=3, two_green=4
how can I build my formula so that when looping through the table, each cell in the table is the right combination?
Pivot table:
red | green
one 1 2
two 3 4
I tried : $(=Only(AA)) & '_' & $(=Only(BB)) right but not evaluated as a varible 😞
Any help will be welcome... Thank's in advance
Today we had an error on one of our Qlik Replicate tasks "Failed to remove file:"
Processing aborted due to error 300002:1355844283; incident 3722464.
to execute statement: REMOVE @"PROD"."PUBLIC"."ATTREP_IS_PROD_bf071f72_b1f9_4dc7_b2f8_919759658d9c"/bf071f72_b1f9_4dc7_b2f8_919759658d9c/0/CDC00000215.csv;
What does this error mean?
Hi!
Thought about asking if anyone can think of a solution for my problem here, since I'm new to Qlik I'm not sure if there is a function that can do that job.
I have a dataset with many duplicated records, but every record has a different Id. I'd like to delete the duplicates and maintain just the first of the duplicated records.
In this example, rows 2-6 are duplicated.
Row_number | Id | Start Station | Departure Time | Final Station | Arrival Time | DepartureTime_Retur | ArrivalTime_Retur | Count Changes | score |
1 | bb945103 | City1 | 07:09:00 | City2 | 12:38:00 | 16:07:00 | 21:46:00 | 1 | -16860 |
2 | 3d63b7b4 | City1 | 07:09:00 | City2 | 12:38:00 | 21:07:00 | 06:45:00 | 2 | -48240 |
3 | 658a5c90 | City1 | 07:09:00 | City2 | 12:38:00 | 21:07:00 | 06:45:00 | 2 | -48240 |
4 | e12f4755 | City1 | 07:09:00 | City2 | 12:38:00 | 21:07:00 | 06:45:00 | 2 | -48240 |
5 | f0770ed2 | City1 | 07:09:00 | City2 | 12:38:00 | 21:07:00 | 06:45:00 | 2 | -48240 |
6 | a107b4e0 | City1 | 07:09:00 | City2 | 12:38:00 | 20:07:00 | 06:45:00 | 2 | -48240 |
7 | fc6fea72 | City1 | 07:09:00 | City2 | 12:38:00 | 21:07:00 | 05:42:00 | 2 | -44460 |
What I'd like to see instead is:
Row_number | Id | Start Station | Departure Time | Final Station | Arrival Time | DepartureTime_Retur | ArrivalTime_Retur | Count Changes | score |
1 | bb945103 | City1 | 07:09:00 | City2 | 12:38:00 | 16:07:00 | 21:46:00 | 1 | -16860 |
2 | 3d63b7b4 | City1 | 07:09:00 | City2 | 12:38:00 | 21:07:00 | 06:45:00 | 2 | -48240 |
7 | fc6fea72 | City1 | 07:09:00 | City2 | 12:38:00 | 21:07:00 | 05:42:00 | 2 | -44460 |
Is there a way to achieve this? I'm attaching a small sample of data as well if there is someone who woul'd like to try a solution here.
I tried Load Distinct, but it doesn't work as I have distinct ID for every row.
Hi All,
I wanted to develop a Report for Multiple Main Assignee Name, please see the below data. Main Assignee Name Can Increase or decrease or maybe Main Assignee Name can be change. So, I want to develop. that Report in dynamic way for every Main Assignee Name. Please See the E.g. in the below. Please any solution for that.
Data
Main Assignee Name | Dispute Name | Dispute Number | State Code |
A | AA | 1 | ZA |
A | BB | 2 | ZB |
A | CC | 3 | ZC |
A | DD | 4 | ZD |
B | EE | 5 | ZE |
B | FF | 6 | ZF |
B | GG | 7 | ZG |
C | HH | 8 | ZH |
C | II | 9 | ZI |
C | JJ | 10 | ZJ |
C | KK | 11 | ZK |
C | LL | 12 | ZL |
Result:
Main Assignee Name: A
Main Asignee Name | Dispute Name | Dispute number | State Code |
A | AA | 1 | ZA |
A | BB | 2 | ZB |
A | CC | 3 | ZC |
A | DD | 4 | ZD |
Main Assignee Name: B
Main Assignee Name | Dispute Name | Dispute Number | State Code |
B | EE | 5 | ZE |
B | FF | 6 | ZF |
B | GG | 7 | ZG |
Main Assignee Name: C
Main Asignee Name | Dispute Name | Dispute number | State Code |
C | HH | 8 | ZH |
C | II | 9 | ZI |
C | JJ | 10 | ZJ |
C | KK | 11 | ZK |
C | LL | 12 | ZL |
Hi
I'm trying to connect ServiceNow data in Qlik cloud,
I was able to connect to ServiceNow instance I see tables but when I click on any of them to see details and pick columns there is nothing but a spinning circle and an error about Qlik Sense error.
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Join us on April 24th at 10 AM ET for the next Do More with Qlik webinar focusing on Qlik’s Data Integration & Quality solutions.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!