Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 247,641 members
  • 2,408 online
  • 2,030,436 posts
  • 152,847 Solutions
Announcements
April 9th: The AI Roadmap: 6 Landmarks for AI-ready Data and Analytics: REGISTER NOW

Welcome to Qlik Community

Recent Discussions

  • No Boards Found
  • forum

    Management & Governance

    Access Denied Error (5) while trying to create new sheet group.

    Hello,We recently upgraded to Qlik Sense on Windows November 2024 Patch 7 and I was excited to try the custom sheet groups feature as we have multiple... Show More

    Hello,

    We recently upgraded to Qlik Sense on Windows November 2024 Patch 7 and I was excited to try the custom sheet groups feature as we have multiple clients who have asked for this. 

    What I'm seeing, however, is that whenever I try to create a new group in a published app using Add To Group > +New Group, I get an Access Denied Error: 5 message. 

    The particulars are:

    • I'm using a test app that I created containing data and one base sheet. (though I see this same behavior on all of our apps)
    • The test app does not have section access. 
    • I create a new unpublished custom sheet (My new sheet) and try to add that to the new group as described above and get the Access Denied Error message. 
    • I am able to create/publish/delete apps. I am able to create/approve/publish/delete custom/community sheets. I can also create stories and bookmarks. In short, I have full Hub and QMC access

    And yet neither I, nor anyone else I work with, can add a sheet to a new group in a published app. Do I need to enable a security rule that's specific to creating sheet groups? If so, what would such a rule look like? I already have a rule to allow creation of app objects.

    Thanks,

    Steve

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Visualization and Usability

    wildcard search

    hi, I am wondering why wildcard searching does not work in our dashboard for filtering. I saw some old posts of a similar nature that suggested that w... Show More

    hi,

    I am wondering why wildcard searching does not work in our dashboard for filtering. I saw some old posts of a similar nature that suggested that we need to change the code to allow it. Is that right? I just want to look for xxxx in the middle of a bunch of text and *xxxx* does not work. However if xxxx is the first 4 characters of a long thread I don't even need the * at all. Is there a way to search differently or do we need to change all the code on our whole large dashboard?

    thanks

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    App Development

    WHAT IS INTERVALMATCH AND HOW IT IS FUNCTION IN QLIKVIEW?

    SALES:LOAD * INLINE [ORDER, PRODUCT, QTY, SALES PRICE001, A, 250, 12.56002, B, 40, 35.67003, C, 900, 56.8004, D, 579, 66.90005, E, 279, 765006, F, 467... Show More

    SALES:
    LOAD * INLINE [

    ORDER, PRODUCT, QTY, SALES PRICE
    001, A, 250, 12.56
    002, B, 40, 35.67
    003, C, 900, 56.8
    004, D, 579, 66.90
    005, E, 279, 765
    006, F, 467, 446
    007, G, 743, 67
    008, H, 378, 68.9
    009, I, 904, 12.4
    ];

    DISCOUNT:
    LOAD * INLINE [

    MINQTY, MAXQTY, DISCOUNT
    4, 100, 27.9%
    5, 200, 29.4%
    76, 400, 12.7%
    78, 455, 9.8%
    86, 566, 41.9%
    33, 342, 90.7%
    ];

    JOIN IntervalMatch(QTY)
    LOAD MINQTY, MAXQTY, DISCOUNT;


    In this why I'm using interval match ? can i use any other function to get the result ? what is the importance of interval match?

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Application Automation

    How to Include Failed App Name(s) in Automation Email

    Hoping someone can help because I have spent way to long trying to figure this out.  I asked the question before on here and got a great answer but , ... Show More

    Hoping someone can help because I have spent way to long trying to figure this out.  I asked the question before on here and got a great answer but , even implementing their suggestions, I cannot figure out what I am doing wrong.  I have an automation (see attached).  

    My first loop is getting a list of all apps where the title has "Hourly" and then refreshing them.  This is the only way I found to do all refreshes in the same loop.  

    Then I get Implode the Reload Ids and loop through that list to get the list of ones where the status was NOT succeed.  Then I say if the filter is list is not empty send an email.  

    I have added in "Get App Info" but every time I get an error.  I have added it to before the "Wait for Reloads.." but out side the loop, After the "Filter List" loop and after the "Condition" but before the email.  All of these have failed. I have validated the App ID being passed is correct also.  I have also validated that I can run the Get App Info for an app successfully on it's own.  

    I've set up the Reload an app and notify your team on Slack but changed it to email and for that one reload activity it works just fine.  Any suggestions?, Assistance?

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Application Automation

    Export Apps in Qlik Cloud

    Is it possible to export more than one app in Qlik Cloud? I created an API then tried to use it in Python. Bu it didn't work out. I want to backup our... Show More

    Is it possible to export more than one app in Qlik Cloud? I created an API then tried to use it in Python. Bu it didn't work out. I want to backup our apps to SharePoint or OneDrive. But i don't want to export apps one by one. How can i do that? Is there a solution for that?

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    App Development

    Binary Load General Script Error

    I trying to do a binary load, but I get error message "General Script Error". How do I solve this issue.  Does it make a difference if the QVF file i... Show More

    I trying to do a binary load, but I get error message "General Script Error". How do I solve this issue. 

    Noor51_0-1713273990093.png

    Does it make a difference if the QVF file is on the server file vs personal drive when loading?

    Also, Is there a way to remove section access after a binary load? 

     

     

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Visualization and Usability

    How to get the core code of a bookmark? Specifically how to see the /*Missing Va...

    Hello there, communityI have the followining issue: I updated the metrics and dimensions in the back end of my report, but after this optimization, th... Show More

    Hello there, community

    I have the followining issue:

     

    I updated the metrics and dimensions in the back end of my report, but after this optimization, the bookmarks used by the users are not working as expected. The bookmarks work partially, without getting the changed dimensions/measures. 

    For instance, I have this bookmark code: 

    {<App={'MobiOffice'},%analyze={'Ad-hoc report'},%dimension={'A/B test group','Billing period'},[%measure.New purchases]={'Intro-price purchases','Direct purchases','$ Direct purchases','New purchases','$ New purchases'},[%measure.Totals & RC]={'$ Total'}/* MISSING VALUES */>}

    The commented part 'MISSING VALUES' is the part I want to see what is actually inside it. I tried to bring back an older version of the report and this way we got some of the missing dimensions and measures, but not all of them. This way I found out that in the 'MISSING VALUES' Qlik actually stores something inside and when it is present it gets it and puts it back in the bookmark. 

    Here is what I see in the bookmark settings:

    Stanislav1_0-1743690771819.png

     

    My question is how can I find what is inside this commented section "MISSING VALUES"?

    I hope I explained everything in detail. If you need any further detail for resolving this issue, I will be more than happy to provide. 

     

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    App Development

    Creating Section Access on Multiple Fields in one Dimension

    Our client has requested to change security on data to include multiple levels - which corresponds to the fields in Product Dimension.Product Dimensio... Show More

    Our client has requested to change security on data to include multiple levels - which corresponds to the fields in Product Dimension.

    Product Dimension has multiple fields, including ID1,ID2,ID3. Our current security is on ID1 only. The request is to change it so different combinations of access based on these 3 columns can be done. For instance:

    1. client A should have access to ID1 = 100 and all ID values within ID2 and ID3
    2. client B should have access to ID1 = 100 and ID2 = 200 and all ID3 values
    3. client C should have access to ID1 = 100 and ID2 = 200 and ID3 = 300

    I have created section access table that looks like below and tried testing ClientC access, but getting Access Denied message. Is there a limitation in Qlik that section access cannot be created on multiple fields w/n the same dimension (except only when those multiple fields are concatenated into 1 field)

    AnnaRodriguez_0-1743793446153.png

    In our process, we only get ID (or IDS) to be used for security. For instance, Client A was provided with ID1 = 100, which implied that all values available under ID2 and ID3 need to be accessible.

    These IDs (especially ID2 and ID3) are not static and new IDs can be added at any time. How do I account for such setup to ensure that access is granted on different combinations of these IDs?

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    App Development

    What is difference between keep and joins? and where we can use keep instead of ...

    I am confused about using JOINs. When I use a left or right join, how do I determine which table is the main one and which one is the secondary table?... Show More

    I am confused about using JOINs. When I use a left or right join, how do I determine which table is the main one and which one is the secondary table? In KEEP, the results are the same whether I use left, right, or inner joins.

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Visualization and Usability

    Unable to Record Script for Qlik Sense in JMeter – "Connection Lost" Error

    We are using the Qlik Sense application in our organization, and before moving it to production, we need to obtain approvals from the load testing tea... Show More

    We are using the Qlik Sense application in our organization, and before moving it to production, we need to obtain approvals from the load testing team. As part of this process, we are attempting to record the application using JMeter.

    However, while trying to record the script, we encounter the following error:

    "Connection Lost. Make sure that Qlik Sense is running properly. If your session has timed out due to inactivity, refresh to continue working."

    Due to this, we are unable to proceed with the script recording. Interestingly, the application works perfectly fine when accessed normally outside of JMeter.

    Has anyone faced a similar issue or can guide us on how to resolve this?

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Weekly Leaderboard

Customer Story

Optimizing Food Relief with Qlik

Qlik empowers Foodbank Victoria with real-time data insights, optimizing food acquisition and distribution to deliver 25 million meals annually while reducing waste and costs across its statewide relief efforts.

Location and Language Groups

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Blogs

Community News

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