Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We are connecting progress DB through ODBC connection in qlik replication and loading the data to Snowflake.
In source we have the data coming fine where as in target the array coulumns are occing as one column.
For example:
we have source columns as abc1,abc2, abc3, abc4, abc5 with values 19,0,0,2,4 in target data is loaded as abc with value 19;0;0;2;4.
Please help us in resolving this issue in qlik replicate.
Thanks in advance.
Hello, I'm trying to use the Engine API to extract information about apps in my Qlik Sense environment, but I'm getting the following error: `Access to the app is denied: UnknownUser`
I'm using the same header as I successfully use for the QRS API ('X-Qlik-User: UserDirectory=<directory>;UserId=<user>'), and I have verified that the user has access to the app I'm trying to fetch details from.
This is the relevant code:
Hi Team,
Could you please give some idea how to achieve multiple to address in for one email based on filter option in excel. I have followed below steps but not able to achieve
Receiving below warning in N printing side
Not find any selected items
Hi All,
I registered for the Qlik Sense Conference in Orlando 2024. The official start date of the conference is June 3rd, but I don't see any sessions available to enroll on that day. What would be the schedule for June3rd?
Thanks
Date Parts Produced
Feb 50
Feb 100
March 100
March 200
I have a table just like above. Can someone please tell me what formula I need to put on KPI measure field to just get month of Feb? It should display 150. The formula I had used previously did not work in this table, but previously my table had 3/3/24 date format. I had used Sum({<Date={"=Month(Date)=3"}>}[Parts Produced])
This formula did not work for above table. Please help! Thank you.
Hey all, i am trying to use the following api for qlik cloud along with the documentation URL:
curl "https://your-tenant.us.qlikcloud.com/api/v1/apps/{appId}" \
-H "Authorization: Bearer <API-key>"
https://qlik.dev/apis/rest/apps/#%23%2Fentries%2Fv1%2Fapps%2F-appId-get
i am using this REST API in Angular 16 (Typescript) however i keep getting an '401 Unauthorized' error. here is my code:
export class ApiService {
constructor(private http: HttpClient) {}
getApp() {
const appId = '<MY-APP-ID>';
const apiUrl = `https://<MY-Company-Tenant.us.qlikcloud.com/api/v1/apps/${appId}`;
const apiKey =
'Bearer <MY-API-KEY>';
const headers = {
authorization: apiKey,
};
return this.http.get<any>(apiUrl, { headers: headers });
}
}
here is a couple screenshots of my test app so far along with the error i am getting:
Now i know this 401 error means the API key isnt being applied or is wrong however i am testing this in another app and the API call works:
Does anyone know why this isnt working?
Hello All,
I am stumped. I need to get the total of a field we are showing cumulative sum using rangesum in a table (by program). We don't want to sum all for this field though, we need to limit total to current year and beyond.
Here is the table displayed currently:
The formula for the last column is correct. I now need to only display the rows with the red highlight (the sum total for the displaying years for each program).
I have tried many combinations of max(aggr...) but I can't seem to get it right.
Can someone help me out?
Here is my cumulative formula (the last column highlighted in green):
RangeSum(Above(
(Sum ( {<Version_PROG = {'Profit & Loss'}
,VersionName_PROG={'FCF'}
>} ValueGroupCurrency_PROG ))
*
(1/(Pow(1+(
Avg(distinct{$<Version_PROG= {'Financials'}
,VersionName_PROG= {'WaCC'}
>}total Quantity_PROG) ),RowNo(total)-1)))
,0,RowNo()))
As always....thank you in advance!!!
Hi everyone,
I wrote this code to load different sales files by month:
FOR i = 1 to 12
// Generate file name based on month
LET vMonth = Pick(i,
'january', 'february', 'march', 'april', 'may', 'june',
'july', 'august', 'september', 'october', 'november', 'december'
);
trace $(i);
trace $(vMonth);
// File path
LET vFile = 'lib://MyData/sales_' & vMonth & '.csv';
trace $(vFile);
// Load data from file
Sales:
LOAD
Date,
Product,
Amount,
Price
FROM [$(vFile)]
(txt, utf8, embedded labels, delimiter is ';', msq);
NEXT i
If I only have 2 files (e.g "sales_january.csv" and "sales_february.csv") in MyData directory, I get a "Cannot open file 'lib://MyData/sales_march.csv' error.
How can I load only existing files without getting this error?
Thanks in advance for your help,
Jose
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!