What API should I use if I want to obtain a list of all my datasources in Qlik? For example, I configured a Postgres connection and extracted 2 tables. Now I would like to get this info from the API - table names, table columns. 

I am not sure what defines a valid expression for variables in the data load editor:

For example: 

INCORRECT:  Let vLastExecDate = max(date);

CORRECT: Let vLastExecDate = peek('date', 0, 'table_name'));

OR

INCORRECT: LET vIsS3TablePresent = NoOfRows('check_s3')>0;

INCORRECT: LET vIsS3TablePresent = if(NoOfRows('check_s3')>0, 1, 0);

What am I missing? This is an issue I face every month and I haven't pinned down what makes an expression valid for LET variable creation method.

I'm facing a problem with a combo chart.
I want to show the maximum and the minimum value of a measure (only two highlighters), but minimum highlighter appears repeatedly in every month and far from the line.

Can someone help me, please?

MEASURE (line): count(distinct Chave_Contrato)

HIGHLIGHTERS
Max: =if(count(distinct Chave_Contrato)=max(total aggr(count(distinct Chave_Contrato),[Mês Ano Registro Contrato])),count(distinct Chave_Contrato),0)
Min: =if(count(distinct Chave_Contrato)=min(total aggr(count(distinct Chave_Contrato),[Mês Ano Registro Contrato])),count(distinct Chave_Contrato),0)

Thanks!

Hello Community,

Recently I discovered that I can make que QlikViewServer Service make a CalData.pgo.xml, so i wanted to do an app to see the document cals assigned and last used, but the Last used date comes encrypte like this:

I want to know if is there any way to decrypt those dates so I can do some kpis with them.

Thank you.

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.