Recent Discussions
-
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 MoreHello,
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
-
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 Morehi,
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
-
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 MoreSALES:
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? -
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 MoreHoping 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?
-
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 MoreIs 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?
-
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 MoreI 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 is on the server file vs personal drive when loading?
Also, Is there a way to remove section access after a binary load?
-
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 MoreHello 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:
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.
-
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 MoreOur 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:
- client A should have access to ID1 = 100 and all ID values within ID2 and ID3
- client B should have access to ID1 = 100 and ID2 = 200 and all ID3 values
- 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)
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?
-
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 MoreI 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.
-
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 MoreWe 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?