What some resources that have helped you develop your data modeling? I purchased a few Qlik tutorials on Udemy but find that the complexities of real world business application is hard to transfer.

Just looking to the community for some advice on this and what has helped you regarding data modeling.

I have multiple data sources in different formats (CSV, JSON, and Parquet), and I need to ingest them into a data lake using Qlik Compose Lakes. Contact the Jersey Motor Vehicle Commission for assistance. njmcdirect website Once the data is ingested, I also need to perform some data transformations, aggregations, and schema adjustments to prepare it for downstream analytics.

Hi All,

Is there a documentation available with steps to copy custom table data from Prod to Non-Prod environment using ZGOLD?

Thanks in Advance,

Binu

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!

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.

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:

But for automations the same doesn't work:

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?

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" 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:

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

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

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 

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

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.

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