Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I'm looking to get some guidance on my issues with section access.
What I need to solve is something looks something like this:
Region | Country | Branch | Product
There could be access given in any permutation of the above "matrix".
So there could be an user with the rights below (<ANY> means any from the database, not just the listed options in section access):
REGION | COUNTRY | BRANCH | PRODUCT |
EU | <ANY> | <ANY> | IMPORT |
EU | HU | BUD | EXPORT |
In this scenario I'd want the given user to access to all "IMPORT" lines what belongs to "EU" AND access to "EXPORT" lines within the branch "BUD" (which is also in EU, HU).
And so on... Would I need to build all 4! (24) combinations?
I have seen a .qvw file floating around (Generate Complex Authorization Script in QlikView ... - Qlik Community - 1690689) to generate a complex access script, however this seems to be very obsolete, nothing happens when converted to .qvf.
Thank you in advance!
Hello!
We face follwing scenario as BI-Provider for our customer.
We create QVDs for frontend apps in a dedicated managed space (e.g. "DWHS ETL") and use these QVDs to load data to apps in another space for "managed analytics" as a main use case.
Some of the advanced users would like to consume the raw-data from the QVDs and create their own apps. The QVDs are created from scripts, that are published to this very space and use an ODBC connection to our production Database.
We would like to allow them access to the managed space "DWHS ETL" through the "can consume data" permission (see https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/DataSpaces/permissions-data-space.htm). However that would also allow them to use the ODBC connection to the production Database. (especially through elevated permissions, as we use a special user for accessing the database which would exceed their permissions)
Is it possible to seperate the permissions in a way, that the "advanced users" can access the QVDs but not the ODBC connection?
BR
Christopher
Hi There,
I look after a number of sites and I have reports from 3 of them that they are having random performance issues.
This did not occur prior to the upgrade.
The issues include Hub staying Blank, Icon not appearing, on a selection the wheel stays spinning etc.
Has anyone else had issues like this?
I am not able to build the functionality for text label hide and show feature based upon user Table selection which is placed inside container. If i try to create variable method also that specific table placed inside container is not showing actions as 'On Activate' or some other actions or table events to complete this functionality in qlik sense cloud. can anyone pls help me to complete this ?. There are three table visuals placed inside that single container. i am trying to create actions for the sheet level also like tracking active sheet to show the text label but the problem here is i need to display text label only if the user clicks on second placed table which is inside container. Text label should not be visible if user navigates to balance 2 tables
hey guys
I am implementing an ML model and the execute prediction option is not available,
even with the Automl Experiment Contributor and Automl Deployment Contributor functions
enabled for the user
Grateful
Dear all,
We have data as below :
ID | PRODUCT | PRODUCT_CODE |
1 | MOBILE | A1 |
1 | MOBILE | A2 |
2 | WATCH | P3 |
2 | LAPTOP | P4 |
3 | LAPTOP | L1 |
We are displaying data in straight table as below :
ID | PRODUCT |
1 | MOBILE / MOBILE |
2 | WATCH / LAPTOP |
3 | LAPTOP |
We are are able to achieve resulting table using below expression in table object by creating PRODUCT column by writing expression as below:
= Concat( PRODUCT, ' / ' )
But the issue is we have almost 90K ID and for all them this expression is taking so much time to load in the table object also we have seen hub also responding slow due to this. We need to know if there is any alternative for this or it is the bug. We are using later version November 2024 patch 5 Qliksense enterprise.
We are not doing anything in data model as we have other many more columns in table objects too.
I have 4 Dimensions in a table [Lock Local Period], [TDW Legal Entity Code], [TDW Amz Reg Jurisdiction] and [TDW Amz Reg] (the field [Full Legal Entity Name] can be ignore as it's the long name of [TDW Legal Entity Code]). See screenshot.
I am trying to create some Measures about [TDW Amz Reg] based on the following 3 dimensions [Lock Local Period], [TDW Legal Entity Code], [TDW Amz Reg Jurisdiction]. For example the (most frequent) Mode [TDW Amz Reg] for [Lock Local Period], [TDW Legal Entity Code], [TDW Amz Reg Jurisdiction] and the Count of the Distinct [TDW Amz Reg] by [Lock Local Period], [TDW Legal Entity Code], [TDW Amz Reg Jurisdiction]. i.e.
=aggr( Mode([TDW Amz Reg]), [Lock Local Period], [TDW Legal Entity Code], [TDW Amz Reg Jurisdiction])
Count(Distinct TOTAL <[Lock Local Period], [TDW Legal Entity Code], [TDW Amz Reg Jurisdiction]> [TDW Amz Reg])
So far so good. Now I want to count of how frequently the Mode [TDW Amz Reg] per [Lock Local Period], [TDW Legal Entity Code], [TDW Amz Reg Jurisdiction] appears. I'm struggling because I don't think Aggr will work with having the [TDW Amz Reg] as a column.
I'm trying to use the Qlik Server single-configurator iframe but I get the following error:
Refused to display [url] in a frame because an ancestor violates the following Content Security Policy directive: "frame-ancestors 'self' [url] "
I added the following proxy configuration in qlik:
X-Frame-Options: SAMEORIGIN
Content-Security-Policy: frame-ancestors 'self' https://my-url.com
But the error keeps appearing. What am I doing wrong? Or do I still need to configure something?
qliksenseserver:14.159.6
Hi Guys,
I created a template using excel which fetches an entire table.
while validating the preview file generated from this template with the data from the dashboard, it is seen that for certain ID's the measure column in the report (eg:total waivers) is showing 0. while its respective dashboard would say for that particular ID, total Waivers = $1250.
Can any one explain me why this is occuring. I am filtering the data inside set analysis. for a particular year and payment time.
EG:
Report from preview mode
ID | Country | Waivers |
1001 | UK | 0 |
1002 | USA | 0 |
Same data seen in dashboard:
ID | Country | Waivers |
1001 | UK | 45000 |
1002 | USA | 50000 |
Br,
Syed
Hallo Leute,
ich habe Probleme mit dem Liniendiagramm, es wird eine konstante Linie angezeigt ,obwohl ich eine bestimmte Anzahl von Besuchen haben: Meine Daten: auf der X-Achse Monat, auf der Y-Achse Anzahl Besuche / Termine. Der Zweck der Auswertung ist über einen bestimmten Zeitraum zu sehen ob Besprechungsräume ausgelastet sind, wann die frei sind oder ob man andere nehmen muss.
In a special episode of Qlik Insider, we’ll explore where we are placing our data and analytics bets in 2025.
Data Flow simplifies, democratizes, and accelerates the last mile of data preparation for analytics, machine learning, and AI.
From product innovation, to technical tips and tricks, to real world success stories, Qlik Connect offers learning opportunities for all levels.
Read how to embed AI-powered analytics to innovate, enhance customer satisfaction, and fuel business growth.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.
Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.
Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!