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.

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:

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:

Having calculated the data collected by employees, I need to summarize them. The final result should be as follows:

@MarcoWedel @RobWunderlich @hic 

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

@hic  @lucas4bi  any help would be appreciated! I am stuck.

The Studio always popup 401 error when I try to connect my Cloud Stewardship by tDataStewardshipTaksInput, even I input the correct username and password.

Hi ,

This pivot table change label name, like give bellow picture Sum(ProfitMTD)  to A  and Sum(ProfitMTD) to B