Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 217,917 members
  • 6,504 online
  • 1,995,973 posts
  • 149,596 Solutions
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Welcome to Qlik Community

Recent Discussions

  • 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

    Qlik Replicate

    Call an API from Replicate

    Hello: We have a need to transform as we replicate using a 3rd party transformer that provides an API. Is there a way to invoke an API for each row as... Show More

    Hello:

    We have a need to transform as we replicate using a 3rd party transformer that provides an API. Is there a way to invoke an API for each row as it is being replicated?

    Thanks,

    Manas.

    Show Less
  • forum

    Move to SaaS

    أكــبر شيــخ روحـانى OO9-O555.1068000- اعمال المحبة والطـاعة

    أكــبر شيــخ روحـانى OO9-O555.1068000- اعمال المحبة والطـاعة
  • forum

    Catalog and Lineage

    Automations and Glossaries in personal spaces

    Even with Private Analytics Content Creator turned off, users with the Automation Creator role can create automations (which I understand must be in t... Show More

    Even with Private Analytics Content Creator turned off, users with the Automation Creator role can create automations (which I understand must be in their personal space), and users with the Steward role are able to create Glossaries in their personal space (but these can be moved to shared/managed spaces).

    As a Tenant Admin, I need to be able to see what users have in their personal spaces.

    From the App Catalog, however, I cannot navigate to users' personal spaces. 

    If I set the App Catalog filters to Glossaries and Owned by others I am able to see glossaries in users' personal spaces:

    Bobby_Tables_0-1714147662035.png

    But for automations the same doesn't work:

    Bobby_Tables_2-1714147700193.png

    I know I am able to see automations from the QMC but this behaviour seems inconsistent. Is this a bug or does anyone know that this is working to design?

     

    Show Less
  • forum

    QlikView App Dev

    Loop in a script

    Hi all, i would need your help on this topic: I am getting following Data under Qlikview: I would like to assign the field-information from "AREA-EAN... Show More

    Hi all,

    i would need your help on this topic:

    I am getting following Data under Qlikview:

    JR_38_0-1714144495534.png

    I would like to assign the field-information from "AREA-EAN" when the Datatyp='AREA'  as own column for the following eans, and then remove the line related to the datatyp "AREA" .

    It should look like this:

    JR_38_1-1714145212860.png

    I set different variables in order to use it in my first loop but the for...next doens´t work.

    INV_RAWDATA:
     
    LOAD * INLINE [
    ID, Datatyp, AREA_EAN, Qty
    1, AREA, A-30-D-00, 1
    2, EANS, 4062171924956, 2
    3, EANS, 4062171874947, 2
    4, EANS, 4062171912946, 1
    5, EANS, 4062171924956, 1
    6, EANS, 4062171924956, 1
    7, AREA, A-29-D-00, 1
    8, EANS, 4062171874930, 1
    9, EANS, 4062171912946, 1
    10, EANS, 4066952504313, 1
    11, EANS, 4066952504320, 1
    12, EANS, 4066952504320, 1
    13, EANS, 4066952504320, 1
    ];
     
    Store INV_RAWDATA into File.qvd;
     
    // set Variable with information
    VARIABLE_I:
     
    set i=1;
     
    LOAD ID, 
         AREA_EAN, 
         Datatyp, 
         Qty
    FROM File.qvd (qvd) where ID=$(i) and Datatyp='AREA';
     
    let i=$(i)+1;
    let AREA=peek('AREA_EAN',0,'VARIABLE_I');
     
    VARIABLE_II:
    LOAD 
    max(ID) as max_i    
    FROM
    File.qvd (qvd);
    let max_i=peek('max_i',0,'VARIABLE_II');
     
     
    // 
     
    FOR i=$(i) to max_i=$(max_i)
     
    RUN:
     
    LOAD 
    '$(AREA)' as AREA,
    ID, 
         AREA_EAN, 
         Datatyp, 
         Qry
    FROM
    File.qvd (qvd) ; 
     
    NEXT

     

    Has somebody any idea how I could get the desired result?

    Show Less
  • forum

    Move to SaaS

    OneDrive Connection Failure

    Hi all, My Qlik Cloud OneDrive data source connection was working properly, and then all of a sudden, my reload tasks started failing & when I try to ... Show More

    Hi all,

    My Qlik Cloud OneDrive data source connection was working properly, and then all of a sudden, my reload tasks started failing & when I try to extract data from any of my existing files in it, I am getting this error message 

    KD2015_1-1713804594965.png

    I can still access the OneDrive folder from the load script & see my files. But when I try to pull any one of them in, I am receiving that error message.

    Any knowledge on how & why this is happening?

    Thank you

     

    Show Less
  • forum

    App Development

    in filter, display the pre-mapped values, but filter by mapped-value 'behind the...

    I have a map below, which related food to fcode. fcode is the key that links multiple tables together.   map1: [food,fcode apple,a apple-pie,a banana,... Show More

    I have a map below, which related food to fcode. fcode is the key that links multiple tables together.

     

    map1:

    [food,fcode

    apple,a

    apple-pie,a

    banana,b

    banana-float,b

    cherry,c

    cherry-coke,c];

     

    Let's say

    Table 1 -uses fruits (applymap() can be used to turn food into fcode)

    Table 2 -uses fcode (can not reverse into food)

    Table 3 -uses fcode (can not reverse into food)

     

    How can i create a filter, such that:

    1. the filter display the food values. (i.e apple-pie and not 'a')

    2. When selecting food values, the filter is applied to all tables (1,2,3). I.e if I select apple-pie (or apple), the filter also set  fcode to 'a' and table 2,3 will display only information relating to 'a'. Note that it is accepted for either apple-pie or apple to be selected to filter for fcode 'a'

    If I use applymap() on table 1, and filter by fcode, i lose context for my users who only understands food.

     

     

     

    Show Less
  • forum

    New to Qlik Analytics

    Default filter Q2

    Hello, similar to my first question, I am applying default filter to my sheet but this time I have several filters. so I wanted to apply actions to my... Show More

    Hello,


    similar to my first question, I am applying default filter to my sheet but this time I have several filters. so I wanted to apply actions to my sheet again.

    First filter:

    Action : select values in a field

    Filed name: FY

    The value I want to show is the current year, so I wrote this formula in the value section:

    FY= '$(=Year(Today()))'

     

    Second filter:

    Action : select values in a field

    Field: Period

    The value I want to show is the pervious month, so I wrote this formula in the value section:

    Period='$(=MonthStart(Today(), -1))'

    other filters:

    Action : select values in a field
    Field: ACC_Type
    Value: A

    Action : select values in a field
    Filed: Level
    Value: Level 1

    when I exit and come back to the sheet, by default ACC_Type and Level filter the sheet and select A and 1, but FY and Period won't be applied.

    Just to try, I removed the formulas and instead just put 2024 as value for FY and 3 as value for Period, and it worked. It filters the table by default when I open the sheet, However, that is not what users wants. They want a dynamic default filter.

     

    let me know how to resolve this.

     

    thank you for your help in advance!!

    Show Less
  • forum

    New to Qlik Analytics

    Default filter

    Hello, I have used filter panes in one of my sheet in qliksense. One of the filters is to select Gender. The filed name in my data source is Gender an... Show More

    Hello,

    I have used filter panes in one of my sheet in qliksense. One of the filters is to select Gender. The filed name in my data source is Gender and it has rows for F (as female) and M( as male). Previously, I had this expression behind my filter 
    if(Gender='F','Female',if(Gender='M','Male')). it works fine.

    Now user wants that every time they open the sheet it filters out the report automatically or by default to Male. and later, if they need then change and select the Female option in the filter.

    I have set this variable in the main section in data load editor SET vDefaultFilter='Male', and modify the expression like this: if(Gender='F','Female','$(vDefaultFilter)')

    the expression says ok but it does not filter data by default to Male. I still need to go and select Male option.

    could someone help please?

    Thank you!

    Show Less
  • forum

    New to Qlik Analytics

    Como criar um QVD de forma dinâmica basado em parametros de outro QVD !!!

    Tenho a seguinte situação: Para cada registro tenho um COD, e um ano_inicio e ano Fim, preciso que crie pra cada COD, as linhas informando que ele per... Show More

    Tenho a seguinte situação:

    Para cada registro tenho um COD, e um ano_inicio e ano Fim, preciso que crie pra cada COD, as linhas informando que ele permaneceu de ano_inicio até ano_fim.

    Exemplo:

    COD | ANO_INICIO | ANO_FIM

    1       |  2002             | 2005

    2       |  2006             | 2008

    Resultado esperado:

    COD | ANO_PERMANC

    1       |  2002           

    1       |  2003

    1       |  2004

    1       |  2005

    2       |  2006

    2       |  2007

    2       |  2008

    Consegui fazer quando no LOAD filtro apenas um COD, segue QVW.

    Show Less
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!