Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 212,757 members
  • 5,661 online
  • 1,987,303 posts
  • 148,807 Solutions
Announcements
Marching toward a simplified navigation! READ ON

Welcome to Qlik Community

Recent Discussions

  • forum

    Design and Development

    Caused by: org.apache.maven.plugin.MojoExecutionException: The Talend Commandlin...

    Hi , I have recently upgrade talend 7.3.1 to talend 8.0.1. In talend 8.0.1  I am not able run command line server on window. I could not find commandl... Show More

    Hi ,

    I have recently upgrade talend 7.3.1 to talend 8.0.1. In talend 8.0.1  I am not able run command line server on window.

    I could not find commandline.bat after unzip talend8.01 file. I found only commandline_upgrade.bat.

    • when try run commandline_upgrade.bat its gives exception "java.lang.RuntimeException: Application "org.talend.commandline.CommandLine" could not be found in the registry" .

     

    • And when I try run below maven commands for regenerate pom file and build packaging then its gives exception  "Caused by: org.apache.maven.plugin.MojoExecutionException:
      *****************************************************
      The Talend Commandline version 0.0.0 is older than project version. Use -Dtalend.studio.p2.update to change the update URL to match or supersede the project version and try again.
      *****************************************************"

    I already try with -Dtalend.studio.p2.update= https://update.talend.com/Studio/8/updates/latest but we have firewall limitation on server so it could not access  https://update.talend.com/Studio/8/updates/latest .

    Maven Commands :- 

    mvn org.talend.ci:builder-maven-plugin:8.0.12:generateAllPoms -Dgeneration.type=local -Dproduct.path=C:\Programs\Talend-StudioV8.0.1 -Dlicense.path=C:\Programs\Talend-StudioV8.0.1 -Dtalend.studio.p2.base=C:\Programs\Talend-StudioV8.0.1 -Dtalend.studio.p2.update=C:\Programs\Talend-StudioV8.0.1

    please suggest how can we resolve theses above issue.

    Any lead would be greatly appreciated.

    Thanks in advance.

     

    Show Less
  • forum

    Integration, Extension & APIs

    Add "Columns" Component in Data Property

    Hi, I'm trying to implement the Data Property with the "Columns" Component that contains measures and dimensions.Like what is in this photo: But I cou... Show More

    Hi, I'm trying to implement the Data Property with the "Columns" Component that contains measures and dimensions.
    Like what is in this photo:

    Nastiapom_0-1660689785100.png

    But I could only figure out how to visualize the dropdown button without measures and dimensions because this part is not documented.

    Nastiapom_3-1660692805237.png

     

    This is the code I arrived at:

    Nastiapom_2-1660691531804.png

    Show Less
  • forum

    Deployment

    Issue in upgrade talend version 7.3.1 to Talend 8.0.1 with pom.xml.

    Recently I have upgrade talend version 7.3.1 to Talend 8.0.1 I faced below major issue after migration of code in talend 8.0.1. I found major differe... Show More

    Recently I have upgrade talend version 7.3.1 to Talend 8.0.1

    I faced below major issue after migration of code in talend 8.0.1.

    • I found major difference in pom.xml file after upgrading code 7.3.1 to 8.0.1. I am not able see modules tag in project pom.xml. In 7.3.1 talend version's pom.xml we have modules section in pom.xml. which is used for  job build in maven command with -pl parameter in CICD by Jenkins. However In talend 8 I can not see whole modules section in pom.xml. Due to this major difference I am not able make to automation build using maven command of talend job.

    2024-03-04 18_05_51-New Text Compare_ - Text Compare - Beyond Compare.png

    Could you please help how can we add modules section in pom.xml using talend studio 8.0.1?

    Any lead would be greatly appreciated.

    Thanks In advance.

     

     

     

    Show Less
  • forum

    Qlik Replicate

    Do Reload target needed after changing any tasks settings or endpoint settings.

    Hi Team,   we are using Qlik replicate tasks we want to verify the scenario where  if we doing any changes in the Task settings or Endpoint setting(so... Show More

    Hi Team,

     

    we are using Qlik replicate tasks we want to verify the scenario where 

    if we doing any changes in the Task settings or Endpoint setting(source or target endpoints)

    Do those changes reflect in the task by "Resume processing' or again we need to run "Reload Target" to be reflected.

     

    Please let us know what is the best approach to do? what happens in both scenarios(Resume processing and Reload Target ) after any change in task?

     

    Thanks 

    N Vivek

    Show Less
  • forum

    New to Qlik Sense

    How to get the previous date last transaction value based on current selected da...

    I am trying to fetch the previous date last transaction value based on date and time.  Here is the sample data  ID Location DateTime Value 101 NY... Show More

    I am trying to fetch the previous date last transaction value based on date and time. 

    Here is the sample data 

    ID Location DateTime Value
    101 NY 1/1/24 10:28 10
    101 NY 3/1/24 22:30 20
    101 NY 3/1/24 10:15 70
    102 CY 10/1/24 9:10 15
    102 CY 15/1/2024 22:18 50
    102 CY  15/1/2024 22:20 100

     

    whenever user selects any date and ID,it should display previous date's last transaction value for that particular ID and current selected date value should be replaced with previous date last transaction value for the same ID

    For Example If i select ID as 101 and Location as NY and date as 3/1/24 it should display as below 

    101 NY 3/1/24 10
    101 NY 3/1/24  10

     

    if i select ID as 102 ,LOC as CY and  Date 15/1/24 ,it should display as below 

    102 CY 15/1/2024 22:18 15
    102 CY  15/1/2024 22:20 15

     

    Any suggestions are appreciated. 

    Thanks.

    Show Less
  • forum

    New to Qlik Sense

    Max count of stock for every week

    Hello,   I have a dataset that looks like this way: several levels of pieces (VAN) counted, that represent stock registered on any single day a specif... Show More

    Hello,

     

    I have a dataset that looks like this way:

    several levels of pieces (VAN) counted, that represent stock registered on any single day

    a specific day (report date)

    the related week (report date week)

     

    Report Date.week | Report Date | Count(VAN) 

    W01                          01/01/24         3373

    W01                          03/01/24         4581

    W01                          05/01/24         5285

    W01                          06/01/24         2536

    W02                          09/02/24          1853

    W02                          10/02/24           5738

    W02                          12/01/24          3752

    W03                          15/01/24          2784

    W03                          18/01/24          1836

    W03                           19/01/24          5184

    W03                            20/01/24         3284

     

    what I need is to have in this table, only the max count of van for each week: as a result, I should have only one day per every week, when the maximum count of van is registered 

    thank you for the help! 

    Show Less
  • forum

    Qlik Compose for Data Warehouses

    Can Compose be a viable solution for a large Enterprise DW?

    Hello, I am a week into developing a POC for using Compose. The goal of this is to demonstrate that Compose could replace our existing SSIS and stored... Show More

    Hello,

    I am a week into developing a POC for using Compose. The goal of this is to demonstrate that Compose could replace our existing SSIS and stored procedure methodology to simplify things. A few concerns have come up and am hoping for some guidance.

    The extent of what we would eventually want to replace is the ingestion of several hundred tables from Qlik Replicate and then processing to build the Enterprise DW. This includes tables from multiple source systems. 

    Concerns

    1. Model development - Because my warehouse includes multiple source systems, common tables like Address, Customer, and State may exist in all of the sources. And due to the number of tables I am dealing with it seems very difficult to look at the Manage Model UI and understand where a table originated from. I realize that the lineage is available but only if you select a table and utilize the drop down one at a time. (Unfortunately the lineage view only displays 23 characters). Seems like the UI could allow for sorting/filtering by Source DB and Schema. Is my only option to rename all Entities like Address_SourceA, Address_SourceB?

    2. Warehouse Tasks - It appears that I would have to create a separate set of Tasks for CDC vs non-CDC which means 2x the maintenance. And with hundreds of mappings plus the possibility of Pre/Post and Table ETLs I just don't see how this can be managed efficiently. Even if you use the "Enable Only" button you still see all of the Logical Entities. There does not seem like a concise way to simply see that Task X includes mappings y, z and the Pre/Post loading ETL. The Task Statements are too granular to really see the overview. There is also no 'version history' for a Task. So if you make a change, or if someone else does, you have no idea what happened. I get there is a Version Control at a higher level, but no visibility into changes.

    3. Data Marts - The lineage is great, but it requires editing the Dimensional attribute and selecting "Show Lineage".  No way to quickly look at a DM object and easily understand it well.

    4. Work Flow - I don't see how this could manage the complexities of loading a DW with dependencies and precedence.  Especially if there are many Warehouse Tasks like I believe we would need. There does not seem to be a way to disable a give tables flow or allow for a restart/reposition if there is something that went wrong in in the flow.

    Any insights/experience is greatly appreciated.

    Thank you

     

     

     

     

     

    Show Less
  • forum

    Connectivity & Data Prep

    Dropping SQL REST Table not working (?)

    Hi, I've just set a script to request data from an API and it works with a loop, changing the id value dynamically. The first iteration works as expec... Show More

    Hi,

    I've just set a script to request data from an API and it works with a loop, changing the id value dynamically.

    The first iteration works as expected, but even tho I drop the table ''message" [the table name] that receives the response, it seems to keep the table in memory and therefore in the next iteration it either concatenates the tables or renames the table to something like message-2 (if I use NoConcatenate).

    What's going on? How can I overcome this?

     

    Show Less
  • forum

    Qlik Application Automation

    Bookmark to another domain with same bookmark use

    The issue is that users can't see the old bookmarks in the reports. I have bookmarks in Profitability and ibase qlik1 and cant see those but different... Show More

    The issue is that users can't see the old bookmarks in the reports. I have bookmarks in Profitability and ibase qlik1 and cant see those but different id like nilesh.jadav@g.com and nilesh.jadav@m.com but username is same how to resolve this issue

    Show Less
  • forum

    New to Qlik Sense

    Download Sheet as PDF is slow

    We have a requirement to use the "Download sheet as PDF"  However, it seems pretty slow (takes more than 60 seconds on average) considering that it ap... Show More

    We have a requirement to use the "Download sheet as PDF"  However, it seems pretty slow (takes more than 60 seconds on average) considering that it appears to be just a screenshot that is saved to a PDF document.  Also, it sometimes fails with the error "An error occurred during export. Please try again."  which I learnt from another post here that it occurs due to a timeout setting that can be increased to avoid the error.

    My question is whether it's normal for "Download sheet as PDF" to take that long, or is it because something has not been configured correctly?  We don't have any issues with other functionality.  If this is normal, we cannot ask our users to use this option as it seems way too long.

    I do not have access to the printing logs to check further.

    Any guidance is greatly appreciated.

    pravinboniface_0-1709178656489.png

     

    Show Less
Leaderboard

Customer Story

Qlik Data Integration & Qlik Replicate story

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.

Customer Story

Building a Collaborative Analytics Space

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.

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!