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 correctly:

The formula for the last column is correct.  I now need to only display the rows with the highlighted field.  The problem is different programs end on different years, so we want the calculated value for the max(BC_Year) for that 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

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?

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! 

Hi,

I am trying to remove the prefix from the header of the vizlib filter which is coming buy default when the filter object is using 2 grid spaces. But when the filter object is expanded to 3 grid spaces the 'select a' prefix is gone and the header title is shown correctly. I have tried all the possible settings in the object but was not able to remove the prefix in dropdown state.

I am using Qlik Enterprise Feb 2024.

Hello all,

I know that there are several similiar topics, but too specific with no big picture included 🙂 I wanted to summarize here and verify with you all possible backup options of Qlik Cloud platform. As far as I know there is no native backup from Qlik side and once someone will remove space/app/qaa/datafile/dc by accident, there is no way how to restore it using Qlik support (there is probably some, but not official and if so I suppose it will be extra paid service).

I have several options on my mind and I would like to hear your opinion or experience so far:

1. Manually and regurarly download content (non sense, too much work)
2. Use Qlik CLI to export all apps as json files + folders as space + other objects as json? 
3. Use QAA and backup apps to Github as json files + folders as spaces + others if possible? (some version here)
   1. Not ideal case for Github version control logic
4. Use some paid external 3rd party tools (products from Motio etc.)

But what I miss in all mentioned solution is to be able to save also configuration of following items (not only apps):

• spaces - members + permissions
• datafiles - reside in spaces
• data connections - reside in spaces
• QAA's - reside in personal space

As there is API utilization possibility within QAA/Qlik CLI there is a chance to cover this portfolio at least partially, but not all mentioned areas can be covered as endpoints are limited and does not contain the content itself, just some metadata of items.

Any idea how to make backups with as much items as possible with reasonable solution?

Regards

petrus