Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 218,009 members
  • 4,202 online
  • 1,995,945 posts
  • 149,588 Solutions
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Welcome to Qlik Community

Recent Discussions

  • forum

    New to Qlik Analytics

    KPI for selected date

    Date             Time Spent 3/5/2024            5 3/15/2024          8 4/17/2024          7 4/24/2024          5 I have one table with above informati... Show More

    Date             Time Spent

    3/5/2024            5

    3/15/2024          8

    4/17/2024          7

    4/24/2024          5

    I have one table with above information.  I need to make a KPI where it only need show month of March's Sum.  Anyone can tell me what formula I need?  Thanks in advance.     

    Show Less
  • forum

    New to Qlik Analytics

    Pareto diagram in Qlik Sense Comdo chart descending bars and ascending accumulat...

    Hi! I need to convert this diagram in QlikView: To  Qlik Sense. Unfortunately I cannot sort the bars descending and the accumulated values line ascen... Show More

    Hi!

    I need to convert this diagram in QlikView:

    Maaa_1-1714320246249.png

    To  Qlik Sense. Unfortunately I cannot sort the bars descending and the accumulated values line ascending.

    Maaa_0-1714320210126.png

     

    I have managed to add the bars and line but need to sort the bars descending and the line ascending.

    Is this possible?

    Show Less
  • forum

    New to Qlik Analytics

    Load exact patitioned QVD-file in ODAG

    Hi, everyone!My last question was about making partitions from one QVD to several smaller.And kind user Brunobertels sent me a link to a post, how to ... Show More

    Hi, everyone!
    My last question was about making partitions from one QVD to several smaller.
    And kind user Brunobertels sent me a link to a post, how to do automatic partitions.

    And now, I have many pratitioned QVD-files and task:
    I have to load those QVD-files which have only data by asked dates in ODAG request.

    I just made a next script:

    //first check if it's not an ODAG request, but a common load from current window
    if '$(odagActive)' = '' then
       set 'odag_Date' = '''01.07.2019''';
    end if;

    [Tasks]:

    LOAD
       TaskID,
       ContactID,
       CompanyID,
       CreationDate,
       TaskExpDate,
       EditDate,
       TaskStatus,
       CreatedUserID,
       ResponsibleUserID,
       TaskName
    FROM[lib://DataFiles/CRM_Tasks_*.qvd](qvd)
    where Match(CreationDate,$(odag_Date));

    But as you can see, it's a bad script, coz it loads all the files(((
    Please help me to load exact files with dates which was requested.

    Here's my QVDs:

    lib://DataFiles/CRM_Tasks_m01_y2019.qvd
    lib://DataFiles/CRM_Tasks_m02_y2019.qvd
    lib://DataFiles/CRM_Tasks_m03_y2019.qvd
    lib://DataFiles/CRM_Tasks_m04_y2019.qvd
    lib://DataFiles/CRM_Tasks_m05_y2019.qvd
    etc till the end of 2020.

    Show Less
  • forum

    Integration, Extension & APIs

    Permission Denied When Exporting and Downloading App

    I am attempting to set up an OAuth client that can be used to programmatically export and download an app from a shared space via the Qlik Cloud REST ... Show More

    I am attempting to set up an OAuth client that can be used to programmatically export and download an app from a shared space via the Qlik Cloud REST API.

    I am successfully able to run the export POST request, "https://<tenant>.<region>.qlikcloud.com/api/v1/apps/<appId>/export",  and receive the location header specifying a temp-contents ID. However, when I try to get the file from temp-contents endpoint via GET "https://<tenant>.<region>.qlikcloud.com/api/v1/temp-contents/<id>", I receive a response with a "404 Not Found" status with the following body:

    {
        "traceId": "a5075a43661a3dde6633722c7ed6e8b5",
        "errors": [
            {
                "code": "TCS-012",
                "title": "Unable to retrieve metadata",
                "detail": "Metadata can't be retrieved",
                "meta": {
                    "locale": "en-US",
                    "errorType": "Error",
                    "sourceErrors": "permission denied"
                }
            }
        ]
    }

    While it is returning a 404 error, the body's message suggests the client does not have sufficient permissions. I get the same error when trying the "/temp-contents/<id>/details" endpoint.

    The client has the 'Analyzer' entitlement with the 'Tenant Admin' role. It is of type 'Web', has the M2M option checked, and has the trusted consent method. 

    It has access to the 'admin.apps:export' and 'admin.apps:read' scopes as well as the "Can view" and "Can edit" space permissions in the shared space that the app I'm trying to export resides. I've also tried different combinations of space permissions and OAuth scopes to no avail.

    My testing workflow has been to retrieve a token via "https://<tenant>.<region>.qlikcloud.com/oauth/token" with the previously mentioned scopes and use that to authenticate for the export and temp-contents requests.

    Am I missing something here? Is there a way that I can debug and evaluate permissions for this, or view what's available in the temporary content service?

    Any help would be appreciated!

    Show Less
  • forum

    Integration, Extension & APIs

    Embedding a chart doesnt work in Chrome/Incognito

    Hello.I'm following these steps to use an IFrame to embed in my Razor Application a Qlik Cloud Sheet.  Qlik Sense Enterprise SaaS: How to embed a char... Show More

    Hello.

    I'm following these steps to use an IFrame to embed in my Razor Application a Qlik Cloud Sheet. 

    Qlik Sense Enterprise SaaS: How to embed a chart in an iFrame  

    From @Damien_Villaret 

    I'm moved to the login page in Chrome, and redirected back to my page where I can see the embedding content with no problem. But, in Firefox or Incognito, I got stuck in a loop where it keeps getting 401 from the /users/me endpoint and the login page returning 302 (It seems like I'm already logged in and I'm redirected back to the returnTo value) but never popping the login page.

    There are no errors in console related to this process apart from the 401.

    qlik.png

     

    P/D: I'm also trying to implement Qlik-Embed with OAuth, but right now I'm only able to see the classic/app version of it, as soon as I put an object or analytics/sheet I get a full empty page with no content. Some of the graphs are not Nebuja.js but I understand that I should be able to see at least the page content rendered. 
    I opened another question about this and link it here, but this post is the most important for me right now as my requirements include sending some variables to the sheet that I cannot do with qlik-embed.

     

    Show Less
  • forum

    Integration, Extension & APIs

    Using Qlik-Embed Object doesn't show any content.

    Hello. I'm trying to move from iFrame to Qlik-Embed based on OAuth 2 authorization because my iFrame is not working properly (Embedding a chart doesnt... Show More

    Hello.

    I'm trying to move from iFrame to Qlik-Embed based on OAuth 2 authorization because my iFrame is not working properly (Embedding a chart doesnt work in Chrome/Incognito).

    My goal is to see a Qlik Cloud sheet inside my Razor application. (This page is a single HTML with js in it)

    The problem I'm facing with this approach is this:

    - I'm able to log in and see the UI=classic/app version of the sheet but when i try doing it in UI=object or UI=analytics/sheet I don't get anything rendered.

    qlik.png

    I understand even though some of the graphics in the page may not be Nebuja.js I have to see the rest of the sheet.

    Show Less
  • forum

    New to Qlik Analytics

    Error

    Hi Everybody, I am facing an issue in chart script i wanted peer values displayed based on the business model, here suppose a corporate is selected it... Show More

    Hi Everybody,

    I am facing an issue in chart script i wanted peer values displayed based on the business model, here suppose a corporate is selected it should display the respected peers in the below table.

     

    nawaz15_0-1714304457874.pngnawaz15_1-1714304490739.png

     

    Show Less
  • forum

    Catalog and Lineage

    Leverage Rest Api using .Net SDK or enigma.js?

    As the title implies, I'm trying to add some features that are currently unavailable through the hub/QMC but are using the API. Are there pros/cons to... Show More

    As the title implies, I'm trying to add some features that are currently unavailable through the hub/QMC but are using the API.

    Are there pros/cons to using either the .net sdk or enigma.js? Is one more maintained than the other?

    I'm much more familiar with .Net as I used to use it before I moved to full time BI Developer.

    Any input is appreciated.

    Show Less
  • forum

    Installing and Upgrading

    Upgrade Qlik Sense 2021

    Hi Dears,   we're facing an issue with upgrading Qlik Sense 2021,  First, I'm unable to upgrade Qlik sense duo to PostgreSQL 9.6. I tried to Upgrade t... Show More

    Hi Dears,

     

    we're facing an issue with upgrading Qlik Sense 2021, 

    First, I'm unable to upgrade Qlik sense duo to PostgreSQL 9.6.

    I tried to Upgrade the PostgreSQL 9.6 with the current available version in the download section but all of the available versions not compatible with the current PostgreSQL 9.6.

    Kindly, any idea how to upgrade the PostgreSQL 9.6 or if you have the download link for the compatible version with 9.6 before I upgrade to the latest.

     

    BsuinessSO_0-1714301392565.png

    I have the following along with qliksenseserver 14.20.10

    • About Service 1.28.0
    • App Migration Service 4.12.2
    • Bot Channel Service to enable chat experience through channels like Slack/Teams 1.19.0
    • Broker Service 5.35.0
    • Capability Service 1.9.1
    • Client 7.233.12
    • Cross-applications search for nl questions 1.16.0
    • Data Preparation Service 3.316.3
    • Dependency Graph Service 1.2.0
    • Dev Hub 1.21.0
    • Download Preparation Service 1.2.5
    • Freya Client Service 2.13.0
    • Licenses service 3.81.0
    • Mobility Registrar Service 1.1.0
    • Monitoring Apps 8.7.0
    • Natural-language broker, a front-facing API for NL utterances 3.14.5
    • Natural-language understanding parser service 0.105.5
    • Notifier service 1.2.0
    • ODAG Service 3.20.1
    • Precedents Service 3.7.0
    • Printing Service 15.31.0
    • Proxy 14.6.0
    • QDC Catalog Service 0.20.2
    • QIB Webchat Service 1.6.1
    • QIX Engine 12.969.6
    • Qlik DataMarket Connector 2.11.0.28
    • Qlik Essbase Connector 1.5.0
    • Qlik Management Console 1.95.1
    • Qlik ODBC Connector 6.118.2
    • Qlik REST Connector 2.82.0
    • Qlik SalesForce Connector 15.74.0
    • Qlik Sense Hub 0.57.4
    • Qlik Web Connectors 4.3.5
    • Repository 28.0.6
    • Scheduler 19.4.0
    • Service Dispatcher 15.17.0
    • Web Extension Service 1.10.0
    • Web Extensions 1.6.0

     

     

    Show Less
  • forum

    New to Qlik Analytics

    Oracle caller interface:ORA-00972 :identifier is too long

     What could be the reason for this Any solution? 
Leaderboard

Customer Story

Qlik Data Integration & Qlik Replicate story

Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.

Customer Story

Building a Collaborative Analytics Space

Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.

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!