Skip to main content

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 175,434 members
  • 13,805 online
  • 1,724,076 posts
  • 131,541 Solutions
  • Announcements
    CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW

    Welcome to Qlik Community

    FOR NEW MEMBERS

    Everything you need to make your Qlik Community experience valuable.

    SEARCH KNOWLEDGE BASE

    Explore official Support and member created content.

    ASK PRODUCT QUESTIONS

    Submit questions to product experts and participate in conversations.

    Analytics

    Forums for Qlik Analytic solutions. Ask questions, join discussions, find solutions, and access documentation and resources.

    Data Integration

    Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources

    Qlik Gallery

    Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.

    Ideation

    Participate in Qlik Technical Previews, submit ideas, and review documentation.

    Support

    Chat with us, search Knowledge, open a Case, read the latest Updates Blog, find Release Notes, and learn about our Programs.

    Events

    Learn about upcoming Qlik related events, webinars and local meetups.

    Groups

    Join a Group that is right for you and get more out of your collaborations. Some groups are closed. Closed Groups require approval to view and participate.

    About Qlik Community

    Get started on Qlik Community, find How-To documents, and join general non-product related discussions.

    Blogs

    Hear directly from Qlik employees in our ten unique blogs.

    Qlik Resources

    Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.

    Qlik Academic Program

    Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.

    Community Sitemap

    Here you will find a list of all the Qlik Community forums.

    Recent Discussions

    • No Boards Found
    • forum

      App Development

      Any better way to split a huge table into differente qvds

      Hi all! I am sure this topic has been discussed tons of time but can´t find a proper answer. Imagine you have table with Millions of registers (for ex... Show More

      Hi all!

      I am sure this topic has been discussed tons of time but can´t find a proper answer.

      Imagine you have table with Millions of registers (for example CDRs calls) and you want to split it into different qvds each of if for a certaing day.

      Right now, what I am doing is a simple loop and store, something like this:

       

      FOR vDay=  $(vDayMin) to $(vDayMax)

      //Load original file
      NoConcatenate
      CDRS:
      load *
      from ..\work\CDRS.qvd (qvd)

      //Load files for vDay
      NoConcatenate
      CDRS_DATE:
      load *
      Resident CDRS
      where day = $(vDay)

      //Store day file
      store CDRS_DATE into ..\output\$(vDay)_CDRS.qvd (qvd)

      drop table CDRS_DATE;

      //Decrease original file without already stored registers

      NoConcatenate
      CDRS_PENDING:
      load *
      Resident CDRS
      where day > $(vDay)

      drop table CDRS;

      store CDRS_PENDING into ..\work\CDRS.qvd (qvd);

      drop table CDRS_PENDING;

      next;

       

       

      With this code, everything works fine, but it taked too long. CDRS original file might be over 100 million registers.

       

      Is there anyway to do it better? some way to iterate vDay within CDRS table only once and "create" on memory CDRS_DAY tables and afterwards make a loop and store all of them?

       

      Thanks a lot in advance.

       

      Regards.

       

      Show Less
    • forum

      New to Qlik Sense

      According to date wise creating the flags for 1 Month, 3 Month, 6 Months, like

      Hi All, I have date filed as DD/MM/YYYY HH:MM:SS format. In script side will derive the 1 month, 3 month, 6 months , YOY flags. 1 Month: -------------... Show More

      Hi All,

      I have date filed as DD/MM/YYYY HH:MM:SS format.

      In script side will derive the 1 month, 3 month, 6 months , YOY flags.

      1 Month:

      ----------------

      If current date is 25/11/2022  - 1 month is --- 25/11/2022 to 24/10/2022

      If current date is 26/11/2022  - 1 month is --- 26/11/2022 to 25/10/2022 Like    1 Month 

       

      3 Months:

      ------------------------

      If current date is 25/11/2022  - 3 month is --- 25/11/2022 to 24/9/2022

      If current date is 26/11/2022  - 3 month is --- 26/11/2022 to 25/9/2022 Like    3 Month 

       

      6 Month:

      ---------------------

      If current date is 25/11/2022  - 6 month is --- 25/11/2022 to 24/5/2022

      If current date is 26/11/2022  - 6 month is --- 26/11/2022 to 25/5/2022 Like    6 Month 

       

      YOY:

      ----------------------

      is Jan to Till date and Previous year of Jan to Current date of Previous date.

       

      Please help on this .

      Thanks advance.

      Ram

       

      Show Less
    • forum

      QlikView Administration

      Qlikview Free version for personal use

      Hello, I used to have a Qlikview free version for my 2 personal documents. I changed computer and I'm looking to downlaod this free version again, but... Show More

      Hello, I used to have a Qlikview free version for my 2 personal documents. I changed computer and I'm looking to downlaod this free version again, but I cannot find it anymore. Any clue ?

       

      Show Less
    • forum

      New to Qlik Sense

      Upgrade and Server Allocation

      If I upgrade my qlik sense server from 13.95 (September 2020) to 14.97 (November 2022), am I right in thinking all the tasks and licence allocation wi... Show More

      If I upgrade my qlik sense server from 13.95 (September 2020) to 14.97 (November 2022), am I right in thinking all the tasks and licence allocation will remain in place and we won't have to set it all up again?

      Show Less
    • forum

      App Development

      Checksum in load script (sum all in two tables - fail when diff)

      What is the best way to introduce a checksum in my load script, and fail when this is not as expected.  Until now I have used a "KPI" chart in my appl... Show More

      What is the best way to introduce a checksum in my load script, and fail when this is not as expected. 

      Until now I have used a "KPI" chart in my application, where if(sum(facts)-sum(reference)=0,'OK','Diff') However I would prefer my script to fail before saving a new version if the checksum is wrong.  Both to be notified immediately of errors when working on an application but also to ensure end users keep last good load if this happens due to poor data quality in production.  (Typically this happens with joins where something is expected to be unique which suddenly isn't)

      Here's an example where the last piece is for explanation and not expected to work. 

      Reference:
      Load * Inline [
      CatREF,ValueREF
      a	,	1	
      b	,	2	
      c	,	3	
      ];
      
      Facts:
      Load 
      		CatREF as Cat
      	,	ValueREF as Value
      
      Resident Reference;
      
      //<--- adding stuff to the Facts table which may duplicate content by accident-->
      
      
      if
              sum(Value)-sum(ValueREF)=0
          then 
              Trace Checksum OK  😄 ;
          Else
              Trace Checksum Failed;
              Exit Script;

       

      Show Less
    • forum

      Integration, Extension & APIs

      ODAG API "Method not allowed"

      I am trying to create ODAG links using the ODAG API, but am getting a "Method Not Allowed" error. I've been successful in using all Repository APIs us... Show More

      I am trying to create ODAG links using the ODAG API, but am getting a "Method Not Allowed" error. I've been successful in using all Repository APIs using the same method and am at a loss about why ODAG doesn't work.

      Url: https://xxxxxxxxxxxx:4242/api/odag/v1/links?xrfkey=0123456789abcdef

      Payload: 
      "{\"name\":\"See Products\",\"selectionApp\":\"2eed5ee0-c584-48e8-8acf-719230831352\",\"templateApp\":\"5a6868eb-5347-42f2-b79e-01c453409c7f\",\"rowEstExpr\":\"count(Product)\",\"properties\":{\"rowEstRange\":[]}}"

      Error: "The remote server returned an error: (405) Method Not Allowed."

      Show Less
    • forum

      Integration, Extension & APIs

      How to create a table and insert data from visualization?

      Is it possible to create a new table (tables) from visualization component and insert/initialize data from visualization code? If there is some exampl... Show More

      Is it possible to create a new table (tables) from visualization component and insert/initialize data from visualization code? If there is some example code somewhere it would be excellent help.

      (QuickTableViewer component was a great example how to query tables and fields and let user to choose from them. Now I would need a way to create tables and initial data according to users selection).

       

      Show Less
    • forum

      New to Qlik Sense

      YOY Sales in Pivot Table

      Hello Folks, I have a pivot table, and I'd like to show % of Change based on the previous year.  Below is my dummy data. DummySales: Load *, DayStart... Show More

      Hello Folks,

      I have a pivot table, and I'd like to show % of Change based on the previous year.  Below is my dummy data.

      DummySales:
      Load *, 
      DayStart(Floor(Num([Sales Date]))) AS %fact_calendar_key, 
      ;
      Load *,
      Date#(SalesDateTxt, 'YYYY-MM-DD') As 'Sales Date'
      ;
      Load * Inline
      [
      	'Product', 'Amount', 'SalesDateTxt'
          'Car Jacks', 5000, '2018-10-10'
          'Car Jacks', 1200, '2017-10-11'
          'Car Jacks', 2500, '2016-10-09'
          'SUV Jacks', 400, '2018-09-10'
          'SUV Jacks', 1200, '2017-09-11'
          'SUV Jacks', 300, '2016-09-09'    
      ]
      ;
      
      Drop Field SalesDateTxt;
      
      MasterCalendar: 
      Left Keep(DummySales)
      LOAD 
       DayStart(Floor(Num(TempDate))) AS %fact_calendar_key, 
       Date(DayStart(TempDate)) AS CalDate, 
       Dual(Year(TempDate), Year(TempDate)) AS Year,
      ;
      //=== Generate a temp table of dates === 
      LOAD 
       DATE(mindate + IterNo()) AS TempDate,
       mindate,
       maxdate // Used in InYearToDate() above, but not kept 
      WHILE mindate + IterNo() <= maxdate;
      //=== Get min/max dates from Field ===/
      LOAD
       MIN(FieldValue('%fact_calendar_key', recno()))-1 as mindate,
       MAX(FieldValue('%fact_calendar_key', recno())) as maxdate
      AUTOGENERATE FieldValueCount('%fact_calendar_key');
      
      EXIT Script
      ;

       

      What I am trying to achieve is something like the following:

       

      Year 2016 2017 2018
      Product
      Car Jacks 108.3333 -316.667 -
      SUV Jacks -75 66.66667 -

       

      What I've tried is 

      Sum({<Year={$(=Max(Year)-1)}>}Amount)

       

      But that doesn't work, because it's looking at the Max of the selectable years, not the value of the current year dimension.

       

      I would like to use Set Analysis if possible, and avoid using Above or other charting keywords.

       

      Any help is greatly appreciated.

      Show Less
    • forum

      New to Qlik Sense

      Filling NULLs with Excel Mapping File

      Hello,  I have a variable 'Fund' in my Table1 and for any NULL values i would like it to match the document_number and document_date from Table1 with ... Show More

      Hello, 

      I have a variable 'Fund' in my Table1 and for any NULL values i would like it to match the document_number and document_date from Table1 with the Document_Number_Blank and Docuemnt_Date_Blank from mapping file and if it is a match then I would like to populate 'Fund' with the Fund_Blank from the MappingFile.  I wrote the script below but continue to get an error saying it cant find Document_Number_Blank. Appreciate any help!

      MappingFile:

      Load

      Document_Number_Blank,

      Document_Date_Blank,

      Fund_Blank

      .....;

       

      Table1:

      Document_Number,

      Document_Date,

        If(Len(Trim(Fund))=0 or Isnull(Fund) and [Document_Number]=Document_Number_Blank and "Document Date" = Document_Date_Blank ,Fund_Blank, if(Len(Trim(Fund))=0 or Isnull(Fund),'Missing Fund', Fund)) as Fund

      .....;

      Show Less
    • forum

      App Development

      User initiated reload of an QS Enterprise app

      Has anyone had success with placing a button, within a Qlik Sense Enterprise app, that allows the users to initiate an app reload?  Any experiences, a... Show More

      Has anyone had success with placing a button, within a Qlik Sense Enterprise app, that allows the users to initiate an app reload?  Any experiences, articles, or resources the community could share?  Is this possible/recommended? Uncertified or paid Extensions are not an option for this client.

      I think it can be done, but I also think any user that can activate the button/reload, must be an ADMIN or have an elevated security rule(s).  Would this increase license costs through the type of license needed? Could ANALYZERS trigger the reload?

      Thank you so much for your attention and participation.

      Show Less

    Blogs

    Community News

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

    Blogs

    Qlik Academic Program Blog

    Read the latest blog around the Qlik Academic Program.

    Blogs

    Qlik Product Innovation Blog

    If you want to know what's new across all of the products in our growing Qlik product portfolio.

    Blogs

    Support Updates Blog

    Get the latest Support information about end-of-product support, new service releases, and general support topics.

    Blogs

    Qlik Design Blog

    Read all about Qlik solutions: scripting, data modeling, visual design, extensions, best practices and more.

    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

    Events and Webinars

    QlikWorld Tour

    Discover your data swagger at a city near you.

    Find your city

    Events and Webinars

    Qlik and Qlik Community Hosted Events

    Subscribe to our Events and Webinar page so you do not miss an event opportunity!

    choose and register

    Event

    Welcome to Qlik

    Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.

    On-Demand

    Events

    Upcoming Events and Webinars

    There is more than one way to find upcoming events, look on the right side of any Qlik Community forum!

    Upcoming