Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Reviewing the Qlik App Automation tutorial I see that the Get Chart Image block exists, however trying to test this block I don't have it as an option within the Qlik Cloud Services connector.
Any ideas?
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Join us on April 24th at 10 AM ET for the next Do More with Qlik webinar focusing on Qlik’s Data Integration & Quality solutions.
Your journey awaits! Join us by Logging in and let the adventure begin.
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.
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.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!