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

I have daily office visit data and a weekly census for that location.  How would I do the following?  I'm thinking I need to use a Total function but it doesn't seem to work.

Visits Syntax:

Count({<Year={$(yearselect)},Source-={'PSHR'},[Location Description]-={'Work From Home'},[Pay Status]={'Active'},Visit_Swipe={0}>} distinct [Employee ID])

Assigned Seats Measure Syntax:

Count( {<Year={$(yearselect)},Source={'PSHR'},[Location Description]-={'Work From Home'},[Pay Status]={'Active'}>} distinct [Employee ID])

Attached some sample data for reference.

Do we have any statement from Qlik that attests to their cloud systems being patched for the below issue? 

https://www.cybersecuritydive.com/news/cactus-ransomware-qlik-sense-cves/714578/

Hey folks.

I have a situation where I need to join a bunch of similar, but not identical, report files into a single.QVD. I've been renaming headers with python before loading but now my boss wants me to get rid of the python step and do it all in Qlik.

The issue is that it's a bunch of .CSV files with slightly different header names. For example "Customer #" vs "Customer number" vs "Client No." There's no option to get these to come in harmonized because they're from different vendors.

I was trying to do something like: Load Distinct If(exists('Customer #'), 'Customer #') as CustomerNumber If(exists('Client No.'), 'Client No.') as CustomerNumber

But I get an error about the headers not being unique even though I'd expect the If() to return nothing when the Exists() condition fails.

Moving the "as CustomerNumber" inside the If() statement is a syntax error.

Is there a way to do this without making temporary tables and conctenating? I'm now doing it this way and it's working but it seems inelegant and like it's more steps than should be needed.

Thanks!

I am trying to create sales info for a customizable "Current Period" and "Prior Period" setup similar to what is in our company's ERP.

I used the same field INVOICE_DATE.autocalendar.YearMonth and created two filters with alternate states for each period.

While that does work on the surface, it feels really limiting because I cannot seem to filter down any dimension field. I am using a pivot table format, and I cannot seem to filter down to one specific customer or product family or sales rep or anything. 

Is there a way around this, or is this just inherent to Alt States in QLIK?

THX!