Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have a data table with multiple time dimensions.
For the example, let's take 3 of them - OrderOpeningDate, ShippingDate, OrderClosingDate.
I will use all of them in the UI app.
In the UI sheet, I will use buttons to select one of the three dimensions I mentioned, and there are filter buttons for time dimensions like Year, Month and more.
So:
* If the user selects OrderOpeningDate field as the leading dimension, the time filters should be OrderOpeningYear and OrderOpeningMonth.
* If the user selects ShippingDate field as the leading dimension, the time filters should be ShippingYear and ShippingMonth.
Let's say there is a bar chart displaying order's quantities per month, and the user want to see data for the first quarter of 2024.
* If the user selects OrderOpeningDate field as the leading dimension, there are 30 orders on January, 26 orders in February and 33 orders in March.
* If the user selects ShippingDate field as the leading dimension, there are 27 orders on January, 34 orders in February and 18 orders in March.
In this case, I need to create a separate Master Calendar for each dimension, which is something I want to avoid. Additionally, I will need some actions when changing the leading dimension.
I want to create a single Master Calendar for all the 3 dimensions.
I would appreciate help on this topic.
Hi All, I have below dataset.
ID | Is this a project? | Registered | Executor | Hours saved | Team |
1 | No | Antonio | Damon | 6 | |
2 | No | Billy | Damon | 10 | |
3 | Yes | Antonio | Erick | 40 | Billy, Erick, George |
4 | No | Cecilia | Faust | 2 | |
5 | No | Ceclia | George | 4 |
Depending on whether it’s a project or not, I need to calculate how many hours each employee in the company saves.
The calculation must be made under the following conditions:
If "Is this a project? = Yes" - must be calculated:
1. How many team members are in the project (including the project manager, project manager in my table is "Executor"),
2. Divide the saved project hours by the number of teams,
3. Allocate those hours to each of them.
The result would be:
Antonio | 10 |
Billy | 10 |
Erick | 10 |
George | 10 |
If "Is this a project? = No" - must be calculated:
1. If a person has registered, that person will be assigned 30 percent of the hours saved.
2. If a person is an executor, then that person is assigned 70 percent of the hours saved.
The result would be:
Antonio | 1.8 | Example: 6*0.3 |
Billy | 3 | Example: 10*0.3 |
Cecilia | 1.8 | Example: 2*0.3+4*0.3 |
Damon | 11.2 | Example: 6*0.7+10*0.7 |
Faust | 1.4 | Example: 2*0.7 |
George | 2.8 | Example: 4*0.7 |
Having calculated the data collected by employees, I need to summarize them. The final result should be as follows:
Antonio | 11.8 |
Billy | 13 |
Cecilia | 1.8 |
Damon | 11.2 |
Erick | 10 |
Faust | 1.4 |
George | 12.8 |
Hi All,
I have below dataset
Date | Company | Value |
1-Jan-24 | a | 100 |
1-Jan-24 | b | 60 |
1-Jan-24 | c | 90 |
1-Jan-24 | d | 100 |
1-Jan-24 | e | 85 |
1-Jan-24 | f | 110 |
1-Jan-24 | g | 200 |
1-Mar-24 | a | 60 |
1-Mar-24 | b | 100 |
1-Mar-24 | c | 70 |
I want to see the sum of latest values for each company. In my case it will be 1-Jan-24 for d,e,f,g (because for these companies only single record is available) and 1-Mar-24 for companies a, b and c( ignore 1-Jan-24 because latest dates is 1-Mar-24 for these companies). So total sum of values will be (100+85+110+200+60+100+70 =725. I want to show this value in KPI.
Could someone help me create a set analysis measure?
Hello,
I would like to know how i can download an older version than the actual of Talend Studio (exemple, the current version is 2024-10, whereas, i want version 2024-03). Because, there is a new developer in the team, and we want to have the same version.
Thanks in advance.
Best regards.
Bérénice
Calling all Qlik enthusiasts! 💙 The Khoros Kudos 2024 awards are here, and Qlik is nominated for 'Best in Class Community'! You know why? Because YOU are the heartbeat of Qlik! 💓 Our vibrant Community keeps the lifeblood of innovation and collaboration pumping through every dashboard and data point. It's time to show the world our pulse is stronger than ever! Voting is as easy as a single click, but it echoes the rhythm of thousands of Qlik users. Let's amplify our collective beat and bring home the 'Best in Class Community' title! Ready to make some noise? Cast your vote, and let's turn up the volume on Qlik Community love! 🎵📊 Together, we're not just users – we're the life force of the Qlik Community! #QlikCommunityHeartbeat"
https://community.khoros.com/idea/khoros-kudos-2024/qlik/766002
Thank you all!
Hey there,
I have a table in my app that contains a few dimensions and 3 measures.
The 3 measures are:
1. Current Period - Represents the amount of money I currently have (based on period selection)
2. Compared Period - Represents the amount of money I had in a selected period (also based on period selection, using a different variable than the one used in current period)
3. Difference - the calculation of money in my current period minus the money in the compared period
Also, I have a variable that gets a number that is used as a threshold for amounts of money (we'll call it $Threshhold).
I'm trying to filter rows from the table based on the next condition:
If the absolute value of the difference between the periods is greater than $Threshold, then keep the value of it in the table, otherwise filter it.
The problem is that I can't find a way to actually filter the values from the table, the become a null value instead.
I tried many IF conditions and also tried using the limitation option in one of the dimensions, but to no avail.
I would really appreciate if someone could help me with this.
(And sorry I cant ease it with real examples).
Thanks!
Hello,
I am trying to create a dashboard that does an automatic location lookup based on a coordinate system using intervalmatch.
For example, I have a location with the following coordinates: X,Y = (5.3,4.1)
And I have a lookup table that contains all the coordinates with different location names:
X_Start, X_End, Y_Start, Y_End, Location
1, 2, 0, 2, Entrance
2, 4, 2, 3, Aisle
4,6,3,5, Driveway
When I do my interval match for the given coordinates, I would want the output to be "Driveway".
Here is the script I used but it didn't really work.
MatchX:
IntervalMatch([XCOORDINATE])
LOAD
X_START,
X_END
Resident
Intervals;
Left Join(T2)
LOAD DISTINCT
XCOORDINATE,
X_START,
X_END,
autonumber(X_START&'|'&X_END&'|'&'X_KEY') as X_KEY
Resident MatchX;
drop tables MatchX;
MatchY:
IntervalMatch(YCOORDINATE,X_KEY)
LOAD
Y_START,
Y_END,
X_KEY
Resident Intervals;
Left join (T2)
Load distinct * Resident MatchY;
Drop tables MatchY, Intervals;
I also tried this solution which didn't work either::
https://community.qlik.com/t5/QlikView-App-Dev/Match-Coordinates-in-between-2-values/td-p/345344
The Studio always popup 401 error when I try to connect my Cloud Stewardship by tDataStewardshipTaksInput, even I input the correct username and password.
Talend Cloud Data Management Platform
Version: 8
Build id: 20240920_1319-patch
Hi Team,
I have data in the following format.
Col1 | Date | Col4 | Col5 |
A | 10/11/2024 | Sp1 | Ap1 |
A | 10/12/2024 | Sp2 | Ap2 |
B | 10/11/2024 | Sp2 | Ap3 |
B | 10/9/2024 | Sp1 | Ap2 |
I need to show all the columns in a table visual. I need to show 1 record per col1 with max date and corresponding values of col4 and col5. Max date need to be calculated only based on col1.
The result I'm looking for is this.
Col1 | Date | Col4 | Col5 |
A | 10/12/2024 | Sp2 | Ap2 |
B | 10/11/2024 | Sp2 | Ap3 |
Any help would be appreciated. Please note I need to do this in the frontend itself.
Hi ,
This pivot table change label name, like give bellow picture Sum(ProfitMTD) to A and Sum(ProfitMTD) to B
Pencil in our most magical conference yet: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL
Fuel your data and AI journey with the right services, delivered by our experts.
With Qlik Answers™, get personalized, GenAI-driven answers from unstructured data, so you can make decisions with confidence. Learn how in our product roadmap keynote and demo.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.
Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.
Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.
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!