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

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 244,155 members
  • 4,920 online
  • 2,027,432 posts
  • 152,541 Solutions
Announcements
Qlik Insider: Product Roadmap Edition on Feb 26, 1 PM ET: REGISTER TODAY

Welcome to Qlik Community

Recent Discussions

  • forum

    App Development

    Complex Section Access

    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 ... Show More

    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!

    Show Less
  • forum

    Qlik Cloud Data Integration

    is it possible for users to allow them access to data (QVDs) in managed space bu...

    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 ... Show More

    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

    Show Less
  • forum

    Deployment & Management

    Performance issues after upgrading to May 2024

    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... Show More

    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?

    Show Less
  • forum

    App Development

    I am not able to build the functionality for text label hide and show feature ba...

    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 t... Show More

    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

    Show Less
  • forum

    Qlik AutoML

    Run prediction option in ML implementation

      hey guys I am implementing an ML model and the execute prediction option is not available, even with the Automl Experiment Contributor and Automl D... Show More

     

    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
    Show Less
  • forum

    App Development

    Slowness issue

    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 displ... Show More

    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.

    Show Less
  • forum

    QlikView App Dev

    Count of Mode of 3 out of 4 dimensions

    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 Entit... Show More

    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.  

    Count Mode.png

    Show Less
  • forum

    Integration, Extension & APIs

    iframe error Content Security Policy

    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 vi... Show More

    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

    Show Less
  • forum

    Reporting Service & Alerting

    report Generated from tabular reporting shows 0 Values for certain ID's but valu...

    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 f... Show More

    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

    Show Less
  • forum

    App Development

    Falsche Interpretation beim Liniendiagramm

    Hallo Leute,  ich habe Probleme mit dem Liniendiagramm, es wird eine konstante Linie angezeigt ,obwohl ich eine bestimmte Anzahl von Besuchen haben: M... Show More

    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. 

    Alihan_02_0-1740583211066.png

     

    Show Less
Leaderboard

Customer Story

Accelerating Decision-Making with Qlik Insights

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.

Customer Story

Efficiency in Agriculture: Nortera's Qlik Triumph

Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.

Customer Story

Revolutionizing aircraft production through Data Analytics

Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.

Location and Language Groups

Choose a Group

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

Collaborate

Healthcare User Group

Healthcare User Group

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

All are welcome

Japan Group

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Brasil Group

Brazil

Welcome to the group for Brazil users. .All discussions will be in Portuguese.

open to all

Blogs

Community News

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