Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Qlik Community Contest

Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
cancel
Showing results for 
Search instead for 
Did you mean: 

Answer the Unanswered!

Win Qlik swag by helping others!


It's easy! Look under the 'Unanswered' category below. Find some posts where you can add value. Reply with a thoughtful and helpful response. Reply to as many posts as you like. Five (5) members with valid replies will be entered to win Qlik swag!

Contest Details:
  • End Date: June 14, 2024 at 5pm EDT
  • Winners Announced: The week of June 17

A few rules:
  1. Responses must provide actionable assistance to the original poster.
  2. Original post must be prior to 3rd June, 2024
  3. Qlik Community Admins reserve the right to review replies and remove any that do not meet the requirements


No purchase is necessary to participate in this event. This event is open only to registered Qlik Community members in good standing, and of at least 18 years of age. (each, a “Participant”). The following are not eligible to enter or win this event: (i) employees, officers, directors and contractors of QlikTech International AB . and any of its parent, subsidiary and affiliated companies; or (iii) the "immediate family members" and/or "household members" of any of the persons set forth in (i) "Immediate family members" shall mean parents, stepparents, children, stepchildren, adopted children, siblings, domestic partners or spouses. "Household members" shall mean people who share the same residence at least three (3) months a year. Participation in the event constitutes Participant's full and unconditional agreement to these terms and to be bound by all Qlik decisions relating to the event, which are final and binding in all respects, Qlik reserves the right to determine and verify the eligibility qualifications of any potential winner. Promotional Items have a maximum approximate retail value of $50 and may not be substituted for cash or other items. Items are available while supplies last, and at the sole discretion of Qlik.. Item will be shipped via mail to the address provided. All items are provided “AS-IS” and without warranty of any kind. PARTICIPANT AGREES THAT QLIKTECH INTERNATIONAL AB AND ITS OFFICERS, DIRECTORS, EMPLOYEES, INDEPENDENT CONTRACTORS AND AGENTS (COLLECTIVELY, THE “QLIK GROUP”) WILL HAVE NO LIABILITY WHATSOEVER FOR ANY INJURIES, LOSSES, OR DAMAGES OF ANY KIND RESULTING FROM ACCEPTANCE, POSSESSION OR USE OF THE PRIZE, OR THIS EVENT NOTWITHSTANDING ANYTHING TO THE CONTRARY, IN NO EVENT WILL ANY OF THE QLIK GROUP BE LIABLE TO PARTICIPANT OR ANY THIRD PARTY FOR ANY SPECIAL, INCIDENTAL OR CONSEQUENTIAL DAMAGES, LOSS OF REVENUES, LOST PROFITS, LOST CAPITAL OR OVERHEAD ARISING OUT OF OR RELATING TO THE EVENT AND THE INTERPRETATION OR ENFORCEMENT OF THESES TERMS, WHETHER BASED ON BREACH OF CONTRACT, TORT (INCLUDING NEGLIGENCE) OR OTHERWISE, WHETHER OR NOT THE QLIK GROUP HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. The Qlik Group’s aggregate and cumulative liability (regardless of the form of action, whether in contract, tort, including but not limited to negligence, or otherwise) shall in no event exceed one hundred US Dollars (USD $100). Entrant further acknowledges and agrees that the Qlik Group neither made nor is in any manner responsible or liable for any warranty, representation or guarantee (express or implied, in fact or in law) in connection with any prize or the use or enjoyment of any Prize.

Recent Discussions

  • forum

    Installing and Upgrading

    Updating TAC Server

    I am trying to do a software update for TAC using the server patch. I have all the configurations for the software update green checked but I keep get... Show More

    I am trying to do a software update for TAC using the server patch. I have all the configurations for the software update green checked but I keep get this message from the Software update > server patch page:
    Software update repository cannot be reached (https://talend-update.talend.com/nexus)Screenshot 2026-06-04 151910.pngScreenshot 2026-06-04 151844.png

    Show Less
  • forum

    Data Movement & Streaming

    ODBC via Data Gateway issues

    Hello Community,I am trying to replace Qlik Data Transfer with ODBC via Data Gateway to load data out of a source system called Seasoft.QDT loads the ... Show More

    Hello Community,

    I am trying to replace Qlik Data Transfer with ODBC via Data Gateway to load data out of a source system called Seasoft.

    QDT loads the tables fine and has been for years. I am also able to connect and pull data via Excel, without issue.

    I am connected to this same Data source via Qlik sense on prem for another customer and that also works as expected.

    The Data gateway, however, is giving me all sorts of issues and I can’t figure it out.

    I have a successful connection to the ODBC via the cloud and can see all the tables.

    when I go select a table, it takes forever, but it eventually shows me this. No preview but I get all the field names as id expect.

    When I try to reload. I get the following

    kauenascimento_0-1780075130187.png

     

    ODBC Driver: PxPlus

    @WeLoveQlik @hugo_andrade

    Thank you in advance for any help.

    Show Less
  • forum

    Qlik Answers

    Enabling AI capabiities in Qliksense

    Hi Team,Good Day !Can anyone please help me to understand if we can enable AI Capabilities in Qliksense Enterprise  allowing Predictive analysis , ana... Show More

    Hi Team,

    Good Day !

    Can anyone please help me to understand if we can enable AI Capabilities in Qliksense Enterprise  allowing Predictive analysis , anamoly detection and more. If anyone has a use case of AI implementation, it will be a great help. 

    Thanks !

    Show Less
  • forum

    Techspert Talks

    STT - Monitoring Qlik Cloud Capacity

    This Techspert Talks session covers: Understanding capacity usage Explore the reporting app Tips for managing consumption   Chapters: 01:08 - Wha... Show More

    This Techspert Talks session covers:

    • Understanding capacity usage
    • Explore the reporting app
    • Tips for managing consumption

     

    Chapters:

    1. 01:08 - What is counted in Capacity
    2. 02:28 - How to get the Consumption Report app
    3. 03:18 - Automating the Consumption Report
    4. 03:57 - Overview of sections in the app
    5. 05:33 - Data for Analysis sheet
    6. 06:37 - What is included in the Peak Day
    7. 08:23 - Apps that don't count towards capacity
    8. 09:30 - How to clean up your consumption
    9. 11:33 - How Answers are measured
    10. 13:12 - Q&A: How are QVDs and Resident Loads counted?
    11. 14:21 - Q&A: How to identify what uses the most data?
    12. 15:16 - Q&A: How to use the App Analyzer with large apps?
    13. 16:08 - Q&A: Will this Report be added to monitoring apps?
    14. 16:47 - Q&A: How to control when capacity is added?
    15. 17:27 - Q&A: Are Parquet files better than QVDs?
    16. 18:15 - Q&A: Is there Personal Space in Data Integration?
    17. 19:08 - Q&A: What AI usage is counted?
    18. 19:35 - Q&A: Is there a best practice for incremental loading?
    19. 20:33 - Q&A: Can the Consumption Report be customized?

     

    Resources:

     

    Q&A:

    Q: How about if you load data from QVD on Cloud in app, make transformations and store it again?

    A: Data for analysis measures the volume of external data loaded into an app and then data stored on the tenant (QVD). So in this scenario, the app loads 0 external data and so it contributes 0 bytes. The he QVD(s) you create or modify will count as datafiles regardless of how or where you "transform" them.

    Keep in mind that Data for Analysis is only counting apps and datafiles in Shared and Managed spaces.

     

    Q: What does the reset of any app takes? So, the app does not gets carried forward for reloads?

    A: A Sense app does not count towards Data for Analysis in these circumstances:

    • App does not load any external data during reload
    • An app which uses "exit script" at the beginning
    • App is deleted
    • App is moved into Personal space

     

    Q: When will the Telemetry app be available?

    A: Consumption Report is updated through an automated process each day. You can request to receive the latest version of our tenant's Consumption Report app from the Console > Settings > Distribute report button.

     

    Q: What if you go over the capacity limit?

    A: There are overage charges for each feature if you exceed capacity. Maybe reach out to your account manager at Qlik to get some details or check the documentation on Qlik help: https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Admin/subscription-options-qlik-cloud.htm

     

    Q: You mentioned that Personal Space isn't counted towards capacity; what about Shared spaces?

    A: Apps and data files stored in Shared and Managed spaces are counted towards Data for Analysis.

     

    Q: How to link IDs to actual users or apps or data files?

    A: Current architecture and GDPR regulations limit our ability to present app and datafile names in the app. This is a known limitation (and frustration!) and we are working on improving this situation, given that we know it is not ideal to have to fetch actual app and datafile names via REST calls on a tenant. Or just search by ID in the Console for apps, datafiles. No fun. Sorry it's not there yet, but stay tuned.

     

    Q: In the capacity consumption deployer, in the first output block it says "**Only available to capacity-based tenants with reports of 100MB or less. Larger reports cannot be deployed via Qlik Automate at this time.** - what does this mean?

    A: There is a limitation with Qlik Automations on the file size that can be handled in the automation. So, if you have a lot usage on your tenant == lots of usage event data and the Consumption Report.qvf is too big to be handled by the Qlik Automation. It's painful and somewhat embarrassing that we haven't solved this one as the automation is much nicer to use than clicking on the button every day. Hopefully with the next generation solution the overall user experience will be improved significantly.

     

    Q: Why aren't these analyzer apps just built into Qlik Cloud?

    A: That would be ideal! We are aware of the limitations and awkwardness of the current design and are working on the next generation of telemetry reporting for customers. I can't share details but we are working to make the actual usage data available directly from the tenant rather than through a Sense app as we do today, which is open more options for how you consume that data. Stay tuned.

     

    Q: How about the data that is being pulled from SQL – every time you load the table via SQL will that count towards capacity?

    A: External data loaded into a Sense app is counted towards Data for Analysis. If you are using other Qlik data tools, that data fetched or moved is counted there.

     

    Q: Hey there, I need a clarification: for those tenants that are NOT on Capacity (so old tenants with user based subscriptions), does the app Capacity consumption show any data?

    A: We capture usage telemetry for all tenants, however, the capacity Consumption Report is only intended for / available in Capacity-based subscriptions. Feel free to reach out to your account manager at Qlik to see about getting some of this telemetry data for your tenant(s) if you are considering Capacity

     

    Q: Is there an API endpoint to get the peak daily usage for the tenant?

    A: You can use the licenses endpoint:  https://mytenant.us.qlikcloud.com/api/v1/licenses/overview which includes this --  {       "name": "dataAnalyticsCapacity",       "valid": "2026-03-07/2050-03-08",       "tags": [         "consumption"       ],       "values": {         "action": "aggregation",         "overageQuantity": 1342177280000000,         "periodType": "fixed",         "quantity": 134271415091200,         "resourceType": "data.volume.consumption",         "scope": "license",         "title": "Data for Analysis",         "unit": "byte",         "visible": true       }     },

     

    Q: How can we find out in advance what the consumption will be like, when we're already in Qlik Cloud an considering migration to the capacity license model?

    A: Work with your account manager at Qlik to get some insights on usage for onprem (and QlikCloud) and as it might translate to Capacity.

     

     

    Community400x200.png

     

    Click here to see transcript

     

    @Tyler_Waterfall 

     

    Show Less
  • forum

    Featured Members

    Bad Zip File: Failed to open ooxml file

    When a Qliksense app is loading a excel file from SharePoint site, I am getting an message as "Bad Zip File: Failed to open ooxml file" attached the i... Show More

    When a Qliksense app is loading a excel file from SharePoint site, I am getting an message as "Bad Zip File: Failed to open ooxml file" attached the image of the error.

    Show Less
  • forum

    Visualization and Usability

    Qlik View Personal Edition Issue

    I was using personal edition of qlikview. I opened some old file of qlikview which was made using a license. It somehow opened in my laptop. Now while... Show More

    I was using personal edition of qlikview. I opened some old file of qlikview which was made using a license. It somehow opened in my laptop. Now while opening personal edition files, it is giving the attached error. How to open my files with personal edition now ?

    Show Less
  • forum

    Qlik Replicate

    Invalid input for table issue

    Good day for all I have created some tasks last week, included the tables  and they was running very but this week the tasks have stopped and when go ... Show More

    Good day for all

    I have created some tasks last week, included the tables  and they was running very but this week the tasks have stopped and when go to the log it shows the message bellow. All the log are showing the same issue.

    Need a help hand to fix it

    Tuesday, June 2, 2026

    9:37 AM

    00539829: 2026-06-02T09:31:34 [TARGET_LOAD     ]E:  Invalid input for table 'Table Name' in line number 1 [1022505]  (sqlserver_endpoint_imp.c:2965)

    00539829: 2026-06-02T09:31:34 [TARGET_LOAD     ]E:  execute statement failed [1022505]  (sqlserver_endpoint_imp.c:3119)

    00539829: 2026-06-02T09:31:34 [TARGET_LOAD     ]E:  Error executing data handler [1022505]  (streamcomponent.c:2034)

    00539829: 2026-06-02T09:31:34 [TASK_MANAGER    ]E:  Stream component failed at subtask 2, component st_2_PRD-AO-T24-LSS-RES  [1022505]  (subtask.c:1504)

    00539829: 2026-06-02T09:31:34 [TARGET_LOAD     ]E:  Stream component 'st_2_PRD-AO-T24-LSS-RES' terminated [1022505]  (subtask.c:1675)

    00539821: 2026-06-02T09:31:34 [TASK_MANAGER ]W: Task 'PRD_AO_T24_LSS_RES_XML_LE_8kb' encountered a fatal error (repository.c:6488)

    Show Less
  • forum

    App Development

    Circular Dendrogram Now Available in Qlik Sense

    Qlik didn't have it.We built it for Qlik.Just released the Circular Dendrogram extension for Qlik Sense, a new way to visualize hierarchical data as a... Show More

    Qlik didn't have it.
    We built it for Qlik.

    circular-dendrogram-qlik-sense-title

    Just released the Circular Dendrogram extension for Qlik Sense, a new way to visualize hierarchical data as a radial tree.

    It is useful when you need to see how a hierarchy is structured, not just compare values or levels. Think org charts, product taxonomies, account hierarchies, cost centers, file structures, scientific classifications, and other nested data.

    Unlike a treemap, it doesn't pack hierarchy by value.
    Unlike a sunburst, it doesn't stack levels in rings.

    Instead, every parent-child relationship is drawn as an edge, with branches fanning out from the center to the leaves. Click a leaf, and the full chain back to the root lights up.

    ➡️ Full announcement on our blog
    Demo app and free trial available.

    Show Less
  • forum

    Visualization and Usability

    Gantt chart without extension

    HiI'm trying to create a Gantt chart like the below. I've tried Patric's link without much success (https://community.qlik.com/t5/Official-Support-Art... Show More

    Hi

    I'm trying to create a Gantt chart like the below. I've tried Patric's link without much success (https://community.qlik.com/t5/Official-Support-Articles/Top-10-Viz-tips-Qonnections-2019-Part-I/ta-p/1580174) plus a few others. I need the breaks between jobs as the project is a contingency plan for a workforce management tool. Is it possible without using an extension? I'm using QS Nov 25

    k_holt69_0-1779959182704.png

     

    Show Less
  • forum

    Qlik Replicate

    [Snowflake Target] Can Qlik Replicate stage data to S3 via Privatelink for bulk ...

    Hi Qlik Support Qlik Replicate can stage data to S3 for bulk Loading to snowflake target. In S3 target endpoint setting there is option "Use AWS Priva... Show More

    Hi Qlik Support

     

    Qlik Replicate can stage data to S3 for bulk Loading to snowflake target.

     

    In S3 target endpoint setting there is option "Use AWS PrivateLink".

    In Snowflake target endpoint setting there is no same option.

     

    Can Qlik Replicate stage data to S3 via Privatelink for bulk Loading?

     

    Best Regards

    Nakagawa

    Show Less
===>else