Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 158,218 members
  • 11,394 online
  • 1,709,130 posts
  • 128,328 Solutions
  • Announcements
    IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS

    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

    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

      REST API data - Select All Fields

      Hello,I have a connection to one of core system's REST API set up. Everything including pagination is working fine for me. I am using WITH CONNECTION ... Show More

      Hello,

      I have a connection to one of core system's REST API set up. Everything including pagination is working fine for me. 

      I am using WITH CONNECTION statement to adjust the URL in order to fetch data from different tables (entities) which REST API provides connection to.

      Only issue here is, that it is really tricky for me to get all the field names which those entities include. My intention is to always fetch all fields from the table but SELECT * does not seem to work.

      One workaround could be to obtain those field names from API using /describe method which API offers. This call returns field names which the particular table includes. But the issue here is that the result of this call in JSON looks e. g.:

      "fields": {
      "company_id": {
      "type": "relation",
      "required": true
      },
      "create_ts": {
      "type": "datetime",
      "required": false,
      "default": "now"
      },
      "create_user": {
      "type": "char",
      "allow_blank": true,
      "max_length": 30,
      "required": false,
      "default": ""
      }

      Which means that each field name is returned as table name (where the table itself includes field's properties like type etc.). And I am not able to get those chidlren table names returned as values so they could be used as field names in the following call to API.

      Does anyone know about any workaround/solution?

      I might have been missing something very simple as I am not so familiar with SQL.

      Thanks a lot. Have a great day.

      Show Less
    • forum

      New to Qlik Sense

      Variable parameter with comma not working

      Hi All, I am using variable parameter but its not working when passing comma (as comma act as a delimiter for a parameter), please suggest how to remo... Show More

      Hi All,

      I am using variable parameter but its not working when passing comma (as comma act as a delimiter for a parameter), please suggest how to remove this error

      In data editor
      SET vScaleNumber=if(($1)>=1000000000, num(($1)/1000000000,'#,##0.0 B') ,
      if(($1)>=1000000, num(($1)/1000000,'#,##0.0 M'),
      if(($1)>=1000, num(($1)/1000,'#,##0.0 K'),
      ($1))));

      in expression

      $(vScaleNumber(Sum({<id={'a','b'}>} (sales*rate))))

      Show Less
    • forum

      Qlik Enterprise Manager

      Attunity Upgrade from 6.6.to 7.0 is done | tasks are running Longer for 52 Plus...

      Hi ,   We have perform an upgrade of our attunity servers . Source Version Attunity 6.6 Target 7.0 Snowflake Version is also upgraded to latest one  -... Show More

      Hi ,

       

      We have perform an upgrade of our attunity servers .

      Source Version

      Attunity 6.6

      Target 7.0

      Snowflake Version is also upgraded to latest one  -- snowflake_linux_x8664_odbc-2.25.2.

      Post this we are seeing that the tasks/ loads which used to run for 3 hours are taking longer time and its running for 52 plus hours.

      We are seeing the slowness when used ATTREP_CDC_LOG table.

      Attaching the logs with this and please let us know if any inputs are needed from our end here.

       

       

       

       

      Show Less
    • forum

      Ideation Discussions

      Can we have option to display the numbers to 1 decimal places, while the measure...

      HI All, Can we have option to display the measure to 1 decimal places, while the measure format is set to Auto. As currently Qlik automatically shows ... Show More

      HI All,

      Can we have option to display the measure to 1 decimal places, while the measure format is set to Auto.

      As currently Qlik automatically shows the measure decimal points based on data for eg in some chart  measure is showing value upto 1 decimal point (10.12M) and in other chart its showing upto 2 decimal point (15.1M), So to make dashboard consistent this option will be really helpful.

      So if there is option to show measure value upto 1 decimal point dashboard will be more consistent means both chart will show values like 10.1 M and 15.1 M respectively.

      Show Less
    • forum

      Qlik Replicate

      Global Transformation in replicate

      can we add a new column to every table with load time of the table.
    • forum

      App Development

      Converting field to date

      Hello all,   I am having an issue with dates, as is everyone.   I have a date loaded from a QVD, to which I don't have direct access.   When I load th... Show More

      Hello all,  

      I am having an issue with dates, as is everyone.  

      I have a date loaded from a QVD, to which I don't have direct access.  

      When I load the date, it shows in the Data Model viewer as an integer.  

      After much searching and understanding, I got desperate and tried everything

      [PA] :
      NoConcatenate
      Load 
       Date(num#([LBE Start Date])),
       Date(num([LBE Start Date])),
      
       Date#(num#([LBE Start Date])),
       Date#(num([LBE Start Date])),
      
       Date([LBE Start Date]),
       Date#([LBE Start Date]),
      
       Date(num#([LBE Start Date]),'DD-MMM-YYYY'),
       Date(num([LBE Start Date]),'DD-MMM-YYYY'),
      
       Date#(num#([LBE Start Date]),'DD-MMM-YYYY'),
       Date#(num([LBE Start Date]),'DD-MMM-YYYY'),
       Date#([LBE Start Date],'DD-MMM-YYYY'),
       Date([LBE Start Date],'DD-MMM-YYYY'),
      
       Date(Date#(num#([LBE Start Date]),'DD-MMM-YYYY')),
       Date(Date#(num([LBE Start Date]),'DD-MMM-YYYY')),
       date(date#([LBE Start Date],'DD-MMM-YYYY')),
       
       Date(Date#(num#([LBE Start Date]),'DD-MMM-YYYY'),'DD-MMM-YYYY'),
       Date(Date#(num([LBE Start Date]),'DD-MMM-YYYY'),'DD-MMM-YYYY'),
       date(date#([LBE Start Date],'DD-MMM-YYYY'),'DD-MMM-YYYY'),
       
       Date#(Date(num#([LBE Start Date]),'DD-MMM-YYYY')),
       Date#(Date(num([LBE Start Date]),'DD-MMM-YYYY')),
       date#(date([LBE Start Date],'DD-MMM-YYYY')),
       
       Date#(Date(num#([LBE Start Date]),'DD-MMM-YYYY'),'DD-MMM-YYYY'),
       Date#(Date(num([LBE Start Date]),'DD-MMM-YYYY'),'DD-MMM-YYYY'),
       date#(date([LBE Start Date],'DD-MMM-YYYY'),'DD-MMM-YYYY'),
      *;
      Load * resident [TEMP PA];

       

      I am still not able to pull a date field from this.  In QS, my calendar date picker is not recognizing anything as a date.

       

      Maybe I should give up coding 🙂

      Show Less
    • forum

      Deployment & Management

      [Qlik Sense Enterprise] - Installing Qlik on Windows 10

      Hi! I'm planning to install a new Qlik Sense Enterprise instance. It would be small, with no more than 8 users at a time and around 4 or 5 apps, so i ... Show More

      Hi!

      I'm planning to install a new Qlik Sense Enterprise instance. It would be small, with no more than 8 users at a time and around 4 or 5 apps, so i was thinking on making the deployment in a Windows 10 machine. I've read in the Qlik Sense website that W10 is supported but is only recomended for testing and development. My question is if is there someone has experience or can give testimony of a QS Enterprise deployment on Windows 10 for production purposes.

      Any help will be appreciate.

      Thanks in advance. 

      Show Less
    • forum

      Qlik Replicate

      Failed to execute bulk insert statement

      Good morning, We are using Qlik Replicate to pull data from iSeries to BigQuery. There is a "bulk insert" error occasionally occur made tasks fail. Af... Show More

      Good morning,

      We are using Qlik Replicate to pull data from iSeries to BigQuery. There is a "bulk insert" error occasionally occur made tasks fail. After resuming  tasks using "Resume processing..." in the web GUI, the tasks keep running fine until the same error occur some days later.  That cycle repeats again and again.

      The tables in BigQuery still populated and look good but the error keep pushing up every day raise our concern.

      Please advise.

      [Details]

      In this example, we have GQSUDC table (same name in iSeries and BigQuery) and GQSUDC__ct (change tracking version).  Checking the log file in Qlik replicate, we learnt that the error occurred when Qlik insert back data from attrep_changes table to GQSUDC__ct. There is a "invalid timestamp" error (red highlight in below error message).

       

      Error message from log file:

      Failed (retcode -1) to execute statement: 'INSERT INTO `quotedb_raw`.`GQSUDC__ct` (`header__change_seq`,`header__change_oper`,`header__change_mask`,`header__stream_position`,`header__operation`,`header__transaction_id`,`COMPNUM`,`POLNUM`,`SDUSER`,`SDCODE`,`SDSTAT`,`SDACTY`,`SDRRPL`,`SDRTAP`,`SDGRP`,`SDDISPLAY`,`SDVERIFY`,`SDASSN`,`SDTABL`,`SDSDTY`,`TRANSCTION_TYPE_FLAG`,`SDUNIT`,`SDDRVR`,`SDDEEF`,`SDDENT`,`SDRDIS`,`SDDAMT`,`SDPAMT`,`SDPRDS`,`header__timestamp`,`SDSTMP`,`DATA_EXTRACT_DATETM`,`DATA_LOAD_DATETM`,`RRN`) SELECT CAST( `attrep_changes789B3994BFC808E3`.`col1` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col2` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col3` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col4` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col5` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col6` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col7` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col8` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col9` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col10` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col11` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col12` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col13` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col14` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col15` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col16` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col17` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col18` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col19` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col20` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col21` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col22` as NUMERIC) , CAST( `attrep_changes789B3994BFC808E3`.`col23` as NUMERIC) , CAST( `attrep_changes789B3994BFC808E3`.`col24` as NUMERIC) , CAST( `attrep_changes789B3994BFC808E3`.`col25` as NUMERIC) , CAST( `attrep_changes789B3994BFC808E3`.`col26` as NUMERIC) , CAST( `attrep_changes789B3994BFC808E3`.`col27` as NUMERIC) , CAST( `attrep_changes789B3994BFC808E3`.`col28` as NUMERIC) , CAST( `attrep_changes789B3994BFC808E3`.`col29` as NUMERIC) , CAST( `attrep_changes789B3994BFC808E3`.`col30` as TIMESTAMP) , CAST( `attrep_changes789B3994BFC808E3`.`col31` as TIMESTAMP) , CAST( `attrep_changes789B3994BFC808E3`.`col32` as TIMESTAMP) , CAST( `attrep_changes789B3994BFC808E3`.`col33` as TIMESTAMP) , CAST( `attrep_changes789B3994BFC808E3`.`col34` as INT64) FROM `quotedb_raw`.`attrep_changes789B3994BFC808E3` WHERE `attrep_changes789B3994BFC808E3`.`seq` >= ? and `attrep_changes789B3994BFC808E3`.`seq` <= ?' [1022502] (ar_odbc_stmt.c:2783)
      00005539: 2022-06-30T01:28:30 [TARGET_APPLY ]E: RetCode: SQL_ERROR SqlState: 42000 NativeError: 70 Message: [Simba][BigQuery] (70) Invalid query: Invalid timestamp string "0000-22-00 00:00:00.000000" [1022502] (ar_odbc_stmt.c:2789)

       

      Thanks,

      Dat

      Show Less
    • forum

      New to Qlik Sense

      Traffic Light KPI

      Hi All fellow Qlik users, I have a set of KPI's that require to be graded in the traditional Red, Yellow, Green traffic light system. My KPI's are: <8... Show More

      Hi All fellow Qlik users,

      I have a set of KPI's that require to be graded in the traditional Red, Yellow, Green traffic light system.

      My KPI's are:

      <80% - RED

      >=80% but <100% - YELLOW

      >=100% - GREEN

      I can get 2 parameters working OK (Red, Green) using the following expression

      if(sum([Completed]/[Target])<0.8,'red',if(sum([Completed]/[Target])>=1,'green'))

      I am struggling to work out how to put the "Yellow" section in the middle

      Can anyone please help with a solution.

      Many thanks in advance,

      David 

      Show Less
    • forum

      QlikView App Dev

      Problem comparing dates

      Hey everyone, I'm trying to do something that seems to be simple, but I can't get the dates to ever be equal. Here's a simple table: PROJECTSTATUS:Loa... Show More

      Hey everyone,

      I'm trying to do something that seems to be simple, but I can't get the dates to ever be equal.

      Here's a simple table:

      PROJECTSTATUS:
      Load PROJECTID,
      PROJECTNUMBER,
      STATUS,
      STATUSUPDATE,
      date(HIDATE, 'M/D/YYYY') as HIDATE,
      Time(HIDATE) as HITIME;

      I want to create a flag that shows 1 or 0 in a table column depending on if the project status was updated this month or not.  I can't seem to get the date to match even with something simple like:

      =if( [HIDATE] = '6/27/2022', 1, 0)  or   =if([HIDATE] = date(6/27/2022), 1, 0)

      it's always false:

      robstar256_0-1656534165918.png

       

      Appreciate any ideas on how to get these to equate!  Thanks!

      Show Less

    Get Started On Community

    Start Here Get Started On Community

    Top Participants

    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

    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