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

Hi Folks

I am trying to download files from a Google Cloud Storage Bucket, and I am having an issue with the tGSGet component. I got the below message on "code" tab on Talend Studio 

I chose several of the fixes that the tool provided me but any didn't work

could anyone help me with this? thanks in advance

Hi,

I have a workflow, where I need to reload massive csvs into some BI tool. Of course, it is much easier to do, if data is compressed into some format or written as RAM dump.

1st approach (compressed) is used in Qlik and Tableau, qvd and tde respectively.

2nd approach (RAM dump) is used in Parquet/Arrow (I use it thru Python/Pandas).

Question - Is there _any_ compressed or RAM optimized format, supported by Power BI?

I mean, free easymorph can read qvd and tde (Tableau), but Power BI can't?

Free python/pandas can read/write RAM optimized files, but Power BI can't?

xlsb (binary Excel) is great, but Power BI is extremely slow with it, even it is the MSFT technology.

Also, Power Bi desktop can't read another pbix (at least I don't know how to do this).

Any suggestions? Thanks!

Hello,

I have an application built in Qlik Sense which is already connected to SSMS. There are already tables pulled over from SSMS, and many reports are built using that data. I am adding a new section in the data load editor, and I am trying to pull another table from SSMS and load it into Qlik Sense. However, every time I write my load script, it gives me an error. Interestingly, when I tried loading the same data into an empty application, it worked fine. What could be the problem preventing me from pulling the data into my existing application?

My load script is simple:

Load:

select ID, Rev1, Rev2,Rev3

From ABCTable

Where Year=2024 and Status= 'Active'

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.

What some resources that have helped you develop your data modeling? I purchased a few Qlik tutorials  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!