Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
2,190 online
Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY

Data Analytics

Forums for Qlik Data Analytics 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

QlikWorld

This forum will provide you with event highlights and related content to get you energized and ready for QlikWorld Online.

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.

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.

Qlik Resources

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

Events

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

Blogs

Hear directly from Qlik employees in our ten unique blogs.

About

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

Community Sitemap

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

Recent Discussions

  • No Boards Found
  • forum

    Qlik NPrinting Discussions

    Some cycled reports generates with __FAILED__

    Hi,I get these issues when trying to cycle a report over a dimension. And for each run I get different reports that fails, so there seems to be no con... Show More

    Hi,

    I get these issues when trying to cycle a report over a dimension. And for each run I get different reports that fails, so there seems to be no consistency between the runs. 

    I have checked the documentation in https://support.qlik.com/articles/000086598 and followed the list of suggestions.

    I have no user filters and only a few object filters in the report. The object filters do not conflict in the Qlik Sense application where the data is being fetched from. 

    But since it is different reports that failes for each run it shouldn't be the filter that conflicts with the cycled dimension in my opinion.

    Skärmklipp1.PNG

     

    Show Less
  • forum

    Deployment & Management

    Security rules on data connections can easily be circumvented

    Okay, there are a few restrictions on this exploit, but nevertheless exploitable in a situation where:Access to data connections have been restricted ... Show More

    Okay, there are a few restrictions on this exploit, but nevertheless exploitable in a situation where:

    • Access to data connections have been restricted by security rules
    • The exploiter can publish an app that has an existing reload task running

    How?  Well, the reload task is not running as the owner of the app, or the task, but as INTERNAL\sa_scheduler.

    All you need to do is:

    LOAD *
    FROM [lib://HiddenDataConnection/file.qvd] (options);

    And wait for the task to run, then duplicate the app to you work folder.

     

    Counterargument

    One may argue that the name of the data connection is hidden, and so is the data structure inside the data connection (especially if it is a folder).

    However, that is not security.  And folder structure and name of data connections is not really secret information.

     

     

    In may real-life case, we had developers in separate bank branches, that were not allowed to see each others data.  But, of course they had the same data structure.  Also, the plan was to name the data connections as 'Bank_A', 'Bank_B', etc.  So guessing the name of another data connection was trivial.

     

     

    If you have a similar setting, you may need to take extra precautions, until Qlik acknowledges this as s security vulnerability. 

     

    Not sure what the best fix would be.  One suggestion is to let the task run as the owner of the task, of course, and not with system wide privileges.

    Show Less
  • forum

    Deployment & Management

    Dynamic Views

    Hi everyone,I'm trying to use Dynamic Views on Qlik Sense 2020 patch 3, I can see the button dynamic Views in sheet edition mode from centralnode but ... Show More

    Hi everyone,

    I'm trying to use Dynamic Views on Qlik Sense 2020 patch 3, I can see the button dynamic Views in sheet edition mode from centralnode but it disappears when i'm accessing from an engine.

    Can anyone helps please ?

    Thank you,

    Regards,

    Mehdi

    Show Less
  • forum

    QlikView App Dev

    Autonumber in Script

    hi all,so as I understand I cannot use AutonumberHash if the data gets reloaded in 2 separate reloads. What I've seen from Help files is that I should... Show More

    hi all,

    so as I understand I cannot use AutonumberHash if the data gets reloaded in 2 separate reloads. What I've seen from Help files is that I should use Hash128 etc, but that returns fields that are very long...

    What do you do guys generally do to get a persistent value across loads?

     

    Thanks

    Show Less
  • forum

    New to Qlik Sense

    Help Please

    hi All,  I am having issues working out what I am doing wrong, below is the expression I'm using to calculate the cover for all departments which work... Show More

    hi All,  I am having issues working out what I am doing wrong, below is the expression I'm using to calculate the cover for all departments which works but when i filter each department to make sure they have enough cover it still shows the same overall figure. how can i link the result to what i have filtered?

     

     

    =avg({<[Cost Ctr]={'1234'}>} CoverLine)+avg({<[Cost Ctr]={'1235'}>} CoverLine)+avg({<[Cost Ctr]={'1245'}>} CoverLine)+avg({<[Cost Ctr]={'1235'}>} CoverLine)

    Show Less
  • forum

    Integration, Extension & APIs

    Qlik Engine JSON API - Access Denied Error (Qlik Sense Enterprise)

    Hello,I have a python script that retrieves the load script from each app in our repository through the JSON API, using certificate authentication. It... Show More

    Hello,

    I have a python script that retrieves the load script from each app in our repository through the JSON API, using certificate authentication. It runs fine for every app except a handful that have section access. I get this response from the API:

    {"jsonrpc":"2.0","id":2,"error":{"code":5,"parameter":"","message":"Access denied"}}

    Does certificate authentication not give root access to apps? The user account I'm plugging into the authentication header does not have access to these apps, but the script does not get any such error when I run it from a scheduled task on a separate server, using the same user account. However, when I run the script adhoc on the server as an admin, I get the access denied errors.

    I found this post Open app error - access denied but I did not find any extra spaces around the section access code.

    Show Less
  • forum

    New to Qlik Sense

    Using alternate state filter in qlik sense

    Hi All,I need some help in alternate state function. I need to apply both alternate state filter and also common filter into bar chart. Let me know if... Show More

    Hi All,

    I need some help in alternate state function. I need to apply both alternate state filter and also common filter into bar chart. Let me know if you know how to perform both filters on Qliksense. Herewith I have attached the picture of issue clearly.

    Show Less
  • forum

    New to Qlik Sense

    Today()-90 giving inaccurate results

    I have an app where I need a column to return "No" for items older than 90 days. I am using the following to create this:if(LastConnectionTime>=Today(... Show More

    I have an app where I need a column to return "No" for items older than 90 days. I am using the following to create this:

    if(LastConnectionTime>=Today()-90, 'No', 'Yes')

    Result:

     

    CreepyCatLady_2-1618420949084.png

    It is working, but it is inaccurate. It is returning "Yes" for items newer than September 2020. As of the posting of this question, 90 days prior to today is January 14, 2021. 

    I'm also a bit confused about why I need to use ">" and not "<", but when I use "<" it returns "No" for current date through Sept 2020 and "Yes" for dates Sept 2020 and prior, so I guess ">" is correct? At this point, I am very confused. 

     

     

    Show Less
  • forum

    QlikView App Dev

    Load Excel Files with different sheets?

    Hello all,I would like to load many Excel files, but they have different tab names. There has been a change in the source system, hence the difference... Show More

    Hello all,

    I would like to load many Excel files, but they have different tab names. There has been a change in the source system, hence the difference in names.

    The problem is that I cannot identify which sheet name to use by looking at the excel file.

    My current code is like this:

    for each vfile in dirlist(...)
    for each vsheet in 'sheet1', 'sheet_1'

    Excel:
    load
    ...
    ...
    from...
    ...

    next vsheet;
    next vfile;

    Works, but of course I get errors that data is not found if the wrong register name is used.

    As an interim solution, I temporarily switch off the error messages via errormode=0 or 1.

    I have searched the community, but only found helpful information as soon as you can use odbc.In my case this is unfortunately not possible because we use LibreOffice, so the excel odbc driver is not installed.


    Does anyone else have an idea, without errormode etc.?

    Thanks and greetings

    Show Less
  • forum

    New to Qlik Sense

    How do I schedule loading data with the data load script ?

    i want to reload the data script daily. is there anyway to do that?

Get Started On Community

Start Here Get Started On Community

Top Participants

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements and other topics.

Blogs

Support Updates Blog

Important and useful support information about end-of-product support, new service releases, and general support topics.

Blogs

Blogs

Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products.

Groups

Covid 19

We are bringing together people and resources in response to the pandemic of Coronavirus, aka COVID-19, aka SARS-CoV-2.

open to all

Groups

QlikView to Qlik Sense

Join the QlikView to Qlik Sense group and help you modernize your BI experience through adoption of Qlik Sense.

open to all

Groups

Qlik Healthcare

This group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights.

750+ Members

Events

Online Conference

Join QlikWorld to hear from Qlik CEO, Mike Capone on activating your data for impact. You’ll also have access over 100 breakout sessions covering data integration and analytics, tips for getting the most out of your data, and a view into what the next generation of BI holds.

May 10-12, 2021

Events

Events & Meetups

Virtual Meetups are now a possibility! With the impact of COVID-19, the Qlik Meetup network has expanded its support to include the ability to host your next Meetup online. Email QlikMeetups@qlik.com to get your virtual Meetup started!’

Events

Direct Relief Uses Qlik to Manage Its COVID-19 Supply Chain

Qlik can help you manage your supply chain risks during COVID‑19.The nonprofit organization, Direct Relief, uses Qlik’s Supply Chain solution to scale its delivery of medical supplies worldwide.

Available on Demand