Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone, I'm new to Qlik Sense and seeking assistance. I have encountered a task wherein I aim to present a list of project names based on their launch status. Currently, these names are displayed collectively in a single box as shown below
The image above is using Concat expression:
concat({<[Launch Status] = {'Launched'}>} distinct [Name],', ')
concat({<[Launch Status] = {'In Progress'}>} distinct [Name],', ')
concat({<[Launch Status] = {'Deferred'}>} distinct [Name],', ')
But I would prefer the list of project names to be displayed in separate text boxes, as depicted in the image below. (This arrangement would enable me to view the list of documents associated with each project simply by hovering over the respective text box)
Would anyone be able to offer guidance or assistance in achieving this? Any help would be greatly appreciated. Thank you in advance 🙂
Hello,
I am facing issue in creating Pie Chart, below is the situation
1. I want to create the Pie chart that shows the Shipping type with only text in "Column A" i.e "TL", "LTL" and "Rail TL"
2. The condition along above is that I want to only show data of distinct shipment numbers from column "Shipment#"
please assist what can I do in this?
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?
I'm running a single node qlik sense and single node NPrint on separate ec2s in AWS. The NPrint server and single engine are running on the same machine as well. I've had issues for a while now getting the two machines to connect via the qlik sense box's proxy address.
I recently had the two machines joined to the same domain and switched the qlik services to utilize the same windows service domain user account. But that hasn't fixed the issue either so far. I've tried to have all of the ports open that the documentation mention but that's yielded no luck either.
Any advice on this issue would be greatly appreciated. Whenever I run the 'run verification' test via the NPrint console, I don't see any logs on my NPrint server get updated either.
Here's some specific questions I have.
Hi,
I have previously successfully used If statements for the colour of bars in bar chart based on the sales year.
However, when I set the background colour to RGB (49,130,189) it works as expected but the If statement IF(SSDate_CY ='2023',RGB (49,130,189)) does not.
Anyone got any ideas why it is not working as expected as the statement was copied from a chart in another QV app that worked 100%
Thanks in advance!
I'm having some trouble joining two tables as described below.
Let’s take the first table as follows:
Table 1
Name |
Date |
John |
02/15/2024 |
Andrew |
02/20/2024 |
Thomas |
03/10/2024 |
Clark |
03/12/2024 |
Jefferson |
03/25/2024 |
Peter |
04/01/2024 |
Susan |
04/10/2024 |
Anderson |
04/20/2024 |
Mary |
04/25/2024 |
Joe |
04/30/2024 |
Now, let’s take the second table:
Table 2
X |
Y |
Z |
Parameter Date |
1 |
2 |
3 |
02/01/2024 |
4 |
5 |
6 |
02/15/2024 |
7 |
8 |
9 |
03/01/2024 |
10 |
11 |
12 |
03/15/2024 |
13 |
14 |
15 |
03/25/2024 |
16 |
17 |
18 |
03/30/2024 |
19 |
20 |
21 |
04/01/2024 |
22 |
23 |
24 |
04/08/2024 |
25 |
26 |
27 |
04/15/2024 |
28 |
29 |
30 |
04/20/2024 |
I need to add parameters X, Y, and Z to Table 1 as follows:
Table 1
Name |
Date |
X |
Y |
Z |
John |
02/15/2024 |
4 |
5 |
6 |
Andrew |
02/20/2024 |
4 |
5 |
6 |
Thomas |
03/10/2024 |
7 |
8 |
9 |
Clark |
03/12/2024 |
7 |
8 |
9 |
Jefferson |
03/25/2024 |
13 |
14 |
15 |
Peter |
04/01/2024 |
19 |
20 |
21 |
Susan |
04/10/2024 |
22 |
23 |
24 |
Anderson |
04/20/2024 |
28 |
29 |
30 |
Mary |
04/25/2024 |
28 |
29 |
30 |
Joe |
04/30/2024 |
28 |
29 |
30 |
That is to say, the field “Parameter Date” from Table 2 must be used to define the Parameters to be added to Table 1.
How can I do that?
Thanks for your help.
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 a table of questions and answers from an account.
Some questions are multi choice and I would like to have a line for each of them.
For example:
QUESTION ID, ANSWER
1, Yes
2, No
3, 1^5^10
For question 3, it is a multi-choice question where the user has selected 3 answers.
I would like to obtain the following final table:
QUESTION ID, ANSWER
1, Yes
2, No
3, 1
3, 5
3, 10
How could I get it?
Hello.
I am trying to calculate the year to date average based on year selected. I do have a Master Calendar with a YearMonth field.
I would like to build a Set Analysis expression so that when certain criteria are fulfilled it calculates my average.
Below is a sample of data where the average value should fall in the Completion Month. As shown in the data, January value will be zero, anyway to force the zero in the chart when there is no value as well (null).
Criteria for the Set analysis expression is:
Products (All)
Product Type (Mens, Women)
YTD Average of days based on End Date.
Hello, I just completed this training course, "Talend Data Fabric Foundations" from this link https://academy.talend.com/student/path/1101486-talend-data-fabric-foundations?sid_i=0
The Description says that I will receive a corresponding badge after completion: Badge: Complete this learning path to earn the Talend Data Fabric Explorer badge. To learn more about the criteria to earn this badge, refer to the Talend Academy Badging Program page.
I see in My Profile new Credential earned, "Talend Data Fabric Explorer", but I didn't receive any verification links (in email, in my Credly account, or otherwise) to share it on LinkedIn profile, like for my other badges. So where can I get this verification link for my "Talend Data Fabric Explorer" badge?
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!