Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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 need to convert a timestamp from UTC to the time zone where the event occurred and then create a field that says whether that time is in Business Hours or After Hours. This is the calculation I currently have for this but it times out when I put it into a visual:
=IF((HOUR(ConvertToLocalTime(call_start_time, time_zone)) >= 8 AND HOUR(ConvertToLocalTime(call_start_time, time_zone)) <= 17), 'Business Hours', 'After Hours')
I have also tried creating a measure called Call Local Time that is:
ConvertToLocalTime(call_start_time, time_zone)
then plugging this calculation into
=IF((HOUR(Call Local Time)) >= 8 AND HOUR(Call Local Time)) <= 17), 'Business Hours', 'After Hours')
The problem is that with the measure being plugged into the dimension the result doesn't seem accurate as it starts calling everything After Hours despite there actually being more of a 50/50 split between after hours and business hours.
I was wondering if its possible to write the calculation in the Data Load Editor and if so, how would I do it?
I am attempting to implement a writeback function. First, I am attempting to link an input box to individual values in a table. My ultimate goal is to select a value in the table, type a new value in the input box, click a button and the value with be updated in the selected table..
Hi,
I have a fact table (f_table) and dimension table (d_table) with below fields.
f_table: country_cd, measure_1
d_table: country_cd, country_desc
In Qlik Sense data manager, I associate both the tables on country_cd field.
Now I add a bar chart to display measure_1 against country_desc. There are many country codes in my fact table which are not in dimension table. All these are displayed against '-' in my bar chart. But I want to display it as 'Unknown'.
I tried changing the dimension (in bar chart) from just "country_desc" to "if(isnull(country_desc), 'Unknown',country_desc)" but it does not help.
Appreciate any suggestions. Thanks!
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?
Hello,
Is it possible to have a Qlik Enterprise manager version November 2023 hosted on a Windows server, that manages Linux hosted Qlik Replicate server, version May 2022?
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.
Hi, what do i miss here??
if(frac(STARTTIME)>=MakeTime(6,45) and frac(STARTTIME)<=MakeTime(15,29,59),'FM',
if(frac(STARTTIME)>=MakeTime(15,30) and frac(STARTTIME)<=MakeTime(22,59,59),'EM','Natt')) as Shift
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!