Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 219,106 members
  • 5,618 online
  • 1,997,881 posts
  • 149,779 Solutions
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik Application Automation

    how to increment the file load ever month without overwriting existing file in Q...

    Need to add new file every month just keeping appending new data with the latest date. I have below query where it will load the data but it is overw... Show More
    • Need to add new file every month just keeping appending new data with the latest date. I have below query where it will load the data but it is overwriting the existing data. this query is currently run automatically as scheduled. Kind suggest how to increment so that it shouldn't be impacted old data.  
    • let prevmon=date(addmonths(today(),-1),'MMM YYYY');

      LOAD
      "As of Date",
      "xxxx",
      "xxx",
      "XXXX",
      "XXXX"
      FROM [lib://Source/SourceLanding/Reports/monthlyDetail report as of $(prevmon).xls]
      (biff, embedded labels, table is [qry For Comments$]);

    Show Less
  • forum

    App Development

    Comparison of difference between two filters.

    Good afternoon, I'm trying to make a comparison between the current period - past period / past period * 100. The goal is to obtain the variation in s... Show More

    Good afternoon, I'm trying to make a comparison between the current period - past period / past period * 100. The goal is to obtain the variation in sales in %. For example, in my filter, I'm comparing the same period in different years: February 2023 and February 2024.

    THE EXPRESSION I'M USING IS:

    ( ( Sum({<Ano_DC={"$(VAnoAtual_DC)"}, Mes_DC={"$(VMesAtual_DC)"}>} TOTAL_ITEM_DC) - Sum({<Ano_DC={" $(VAnoAnterior)"}, Mes_DC={"$(VMesAtual_DC)"}>} TOTAL_ITEM_DC) ) ) / Soma({<Ano_DC= {"$(VAnoAtual_DC)"}, Mes_DC={"$(VMesAtual_DC)"}> } TOTAL_ITEM_DC)

    VARs
    VAnoAtual_DC:
    =MAX(Ano_DC)
    VAnoAnterior:
    =MAX(Ano_DC) -1
    VMesAtual_DC:
    =MAX(Mes_DC)

    Show Less
  • forum

    Deployment & Management

    Qlik Sense Upgrade Failed at ServiceDispatcher Step

    Hi, Recently we tried to upgrade our Qlik Sense from May 2023 to August 2023 (IR). The upgrade went well for DEV and QA servers. But it failed on prod... Show More

    Hi,

    Recently we tried to upgrade our Qlik Sense from May 2023 to August 2023 (IR). The upgrade went well for DEV and QA servers. But it failed on production servers. We had to restore production servers with backed up AMI. Now we are investigating the reason why it failed. We have realized that we made a mistake when upgrading QS production which has two nodes: We stopped services on both nodes and then ran installation on two nodes at the same time. We know it is incorrect. But why did it cause problem? I am writing a report and need to gather deeper information.

    Based on installation log files, I can tell the failure occurred at ServiceDispatcher step. Error occurred when it tried to create schema 'qlik_notifier_service'. I checked the log file for the successful installation on DEV server. When it tried to create schema 'qlik_notifier_service' there, it skipped this step because "Schema 'qlik_notifier_service' already exists" (the sentence in log). Why did the installation not skip it during production installation?

    The attached ServiceDispatcher_installation_logs.txt contains related content from log files.

    We need to make sure there is nothing else which caused installation failure. Please advise.

    Thanks

    Show Less
  • forum

    New to Qlik Analytics

    Qliksense Map Area Layer won't highlight certain cities

    Hi, I am currently working with Qliksense Desktop and I noticed that some cities in my country wouldn't get highlighted in the Area Layer in the Map o... Show More

    Hi, I am currently working with Qliksense Desktop and I noticed that some cities in my country wouldn't get highlighted in the Area Layer in the Map object, even some smaller cities will be highlighted. Some weird things I noticed are that Qliksense did auto-generated the GeoInfo for the cities that are not highlighted in the data model viewer so I guess they were recognized by Qliksense right..? And also the Map Object will pin point all the cities just fine in the Point Layer but just not in the Area Layer. Just wondering is there any solution for that or this is some of the limitations of the Map object? Any help will be greatly appreciated!

    Show Less
  • forum

    Qlik Replicate

    Qlik Replicate August 2021 Service Release Now Available

    We are pleased to announce that the Qlik Replicate August 2021 service release (version 2021.5 SR3) is now available.   This release includes support ... Show More

    We are pleased to announce that the Qlik Replicate August 2021 service release (version 2021.5 SR3) is now available.   This release includes support for Databricks on Google Cloud as a new target endpoint as well as support for PostgreSQL 13 as both a source and target endpoint.  

    More information on the exciting new features available in Qlik Compose and Enterprise Manager for August can be found here.

    And more information on the other August 2021 client-managed releases can be found on the product innovation blog.  

    Show Less
  • forum

    Qlik Replicate

    What comes first, the lookup or the filter?

    Hi, I am wondering when I have a source lookup on a column in a table, then I also have a filter on the table. What comes first? Are the records filte... Show More

    Hi,

    I am wondering when I have a source lookup on a column in a table, then I also have a filter on the table. What comes first? Are the records filtered then the source lookup occurs? or does the source lookup occur then the rows are filtered?

    Regards,

    Mo

    Show Less
  • forum

    Qlik Replicate

    MS-CDC for SQL Server we are getting error for Capture job

    Hi Team ,    We are replicating data from SQL Server to Postgresql For SQL Server we are using MS-CDC for real time replication. But its Capture job i... Show More

    Hi Team , 

     

    We are replicating data from SQL Server to Postgresql

    For SQL Server we are using MS-CDC for real time replication. But its Capture job is getting failed with error 

    nested limit exceed 32.

    Version for SQL server is 2017 standard edition.

     

     

     

    Any solution or ideas is appreciated !!!

    Show Less
  • forum

    Qlik Replicate

    Snowflake Target Endpoint - Support new Hybrid Tables as Targets

    In March of 2024, Snowflake announced that Hybrid Tables are now in QA. Will the Snowflake target endpoint connector be modified to support replicatin... Show More

    In March of 2024, Snowflake announced that Hybrid Tables are now in QA.

    Will the Snowflake target endpoint connector be modified to support replicating data to Hybrid Tables as well as traditional Snowflake tables? Is this on the roadmap?

    https://docs.snowflake.com/en/release-notes/2024/other/2024-03-05-hybrid-tables
    https://docs.snowflake.com/en/release-notes/2024/other/2024-03-13-hybrid-tables

     

    Show Less
  • forum

    Move to SaaS

    How to reload Large Qlik Apps in Qlik SAAS environment since I am getting quote ...

    Hi Team, I am getting below error when loading data in Qlik SAAS environment. Your quota limit of 5120.0MB was exceeded. you loaded 10098.1 MB.  Reduc... Show More

    Hi Team,

    I am getting below error when loading data in Qlik SAAS environment.

    Your quota limit of 5120.0MB was exceeded. you loaded 10098.1 MB.  Reduce your data within this application or buy additional capacity.

    Please suggest a solution on this. Can you tell me some ways to reduce the data.

    Thanks

    Vishnu

    Show Less
  • forum

    App Development

    Passage as parameter of set of values ​​separated by comma

    Hi, This is my first partipation in the Forum. I need some help with my app. I have a master measure to count dengue cases from December 2022 to April... Show More

    Hi,

    This is my first partipation in the Forum. I need some help with my app.

    I have a master measure to count dengue cases from December 2022 to April 2023. The problem is that to filter the months I use a variable that contains the aggregation with an analysis set that filters the months, and I call it as a function with the year as a parameter (to be able to apply it to 2023/24) but with this I end up taking the months of the year that passed as a parameter, that is, if it is 2023 it takes: January, February, March, April and December, instead of taking : December (2022), January, February, March and April, that is, December is also 2023. 

     

    I tried to solve it by making a condition in my master measure so that when the month is December, I pass the previous year and the month of December as parameters, and if the month is any of the remaining months, I pass the current year and those months. I think it can work but when I spend several months as the 2nd parameter, it cuts off at the first comma it finds.

    I give you a bit of the code of how I have proposed it. Notice for the abbreviations and names of variables, measures and dimensions are in Spanish

    My master measure

    if(Mes='Dic',${vCantCasos(2022,'Dic')},${vCantCasos(2023,${vSetMesesSinDi})})

    The error

    MauriAuat_3-1715288489691.png

     

    First simple solution but didnt work by the single quotes:
     
    ='Ene,Feb, Mar, Abr' (this would be a variable)
     
    Second solution that almost work but I have the issue with the comma:
     
    MauriAuat_1-1715289340920.png

     

     Finally, I share this other alternative because I need for the set analysis for the month values ​​to be passed as strings with single quotes, but from the beginning it did not work (I also share the error it gives me).

     

    MauriAuat_3-1715289570713.png

     

    I don't know how to move forward and I've already looked for the solution but I can't find anything that is useful to me. I hope that with what I shared you can understand everything and someone can give me a hand. From already thank you very much

     
     
     
     
    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!