Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 233,470 members
  • 1,451 online
  • 2,016,642 posts
  • 151,430 Solutions
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW

Welcome to Qlik Community

Recent Discussions

  • forum

    New to Qlik Analytics

    Creating a Master Calendar for multiple time Dimensions

    Hi everyone, I have a data table with multiple time dimensions.For the example, let's take 3 of them - OrderOpeningDate, ShippingDate, OrderClosingDat... Show More

    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.

    Show Less
  • forum

    New to Qlik Analytics

    complex calculation condition help

    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 A... Show More

    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

     

    @MarcoWedel @RobWunderlich @hic 

    Show Less
  • forum

    New to Qlik Analytics

    Sum of most recent values for company in KPI object

    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 ... Show More

    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?

    Show Less
  • forum

    Installing and Upgrading

    Install an older version of Talend Studio

    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... Show More

    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

    Show Less
  • forum

    Water Cooler

    We need your vote! Qlik is running for Best in Class Community

    Calling all Qlik enthusiasts! 💙 The Khoros Kudos 2024 awards are here, and Qlik is nominated for 'Best in Class Community'! You know why? Because YO... Show More

    Kudos Awards Voting Open - Instagram 1080 x 1080.png

    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! 

    Show Less
  • forum

    App Development

    Table cannot be filtered based on null values

    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 mo... Show More

    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!

    Show Less
  • forum

    Connectivity & Data Prep

    Interval Match for Coordinate System

    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... Show More

    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.

    Show Less
  • forum

    Design and Development

    The Studio cannot connect to Cloud Stewardship

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

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

    Screenshot 2024-10-13 at 17.44.22.png

    Screenshot 2024-10-13 at 17.42.40.png

     

    Talend Cloud Data Management Platform

    Version: 8

    Build id: 20240920_1319-patch

    Show Less
  • forum

    New to Qlik Analytics

    Show all columns for the record with max date in a table visual

    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/202... Show More

    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. 

    Show Less
  • forum

    App Development

    Pivot Table

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

    Hi ,

     

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

    kumaru_1-1728785349129.png

     

     

     

     

    Show Less
X
Leaderboard

Customer Story

Accelerating Decision-Making with Qlik Insights

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.

Customer Story

Efficiency in Agriculture: Nortera's Qlik Triumph

Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.

Customer Story

Revolutionizing aircraft production through Data Analytics

Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.

Location and Language Groups

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Healthcare User Group

Healthcare User Group

A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..

All are welcome

Japan Group

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Brasil Group

Brazil

Welcome to the group for Brazil users. .All discussions will be in Portuguese.

open to all

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!