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

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 max year value (by program) of cumulative field from a table we have limited 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 max year for each program).  The problem is different programs end on different years, so we want the calculated value for the max(BC_Year) for that program and display only that row.

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