I have a table (Table1) with the following columns:
Job number | Start date | End date | Reference date | Remaining job amount | Total job days

Remaining job amount: monetary value that signals how much company still needs to pay for the job
Total job days: total number of days that the job is running; calculcated  by end date - start date + 1

I want to create a loop that adds 14 new columns to the table. The column names should be the next 14 month-ends starting from the Refence date. The loop should calculate and assign what remaining job amount is to be paid in the next 14 months, so the company can see what payments are due for those next 14 months.

I do this by calculating the number of days for the 14 next months, divide this number by the total job days and multiply it by the remaining job amount. 

I wrote the following FOR loop for this:

LET vStartDate = MakeDate(2024, 09, 30);
LET vEndDate = MakeDate(2025, 10, 31);
LET vMaxColumns = 14; 
LET vColumnCount = 0;
SET vColumns = ''; 

FOR vDate = vStartDate TO vEndDate STEP 1
   IF Day(vDate) = Day(MonthEnd(vDate)) THEN

      LET vDateFormatted = Date(vDate, 'DD-MM-YYYY');

      LET vCurrentColumn =
         'max(0, min([Start date], Date(' & vDate & ')) - ' &
         'max([Start date], Date(' & vDate & ') - Day(Date(' & 
         vDate & ')) + 1) + 1) * [Remaining job amount] / 
         [Total job days] ' &
         'AS [Month' & vDateFormatted & ']';

      LET vColumns =
         If(Len(Trim(vColumns)) > 0, vColumns & ', ', '') & 
        vCurrentColumn;

      LET vColumnCount = vColumnCount + 1;

      TRACE Generated column: Month_$(vDateFormatted);

      // Stop loop if maximum # columns has been reached
      IF vColumnCount >= vMaxColumns THEN
         EXIT FOR; 
      ENDIF
   ENDIF
NEXT vDate

NoConcatenate
Table2:
LOAD
[Job number],
[Start date],
[End date],
[Reference date],
[Remaining job amount],
[Total job days],
$(vColumns) 
RESIDENT Table1;

By adding the TRACE statement I can see in the log that Qlik is not exiting the loop properly and is not moving on to the next part of the script when it hits the maximum of 14 columns. So, it is stuck at creating the last month-end column 'Month_31-10-2025'. 

I suspect it has to do with my ending of the loop; but I cannot figure out exactly what it is. 

Hi 

I am trying to send a API request into Qrs,

The purpose is to save the last click of the user about some topic like language, date format etc.

When user clicks on its preference, I want to save it into custom property (in the qrs?), and every running I will read it into var, and when the app is loaded the selection will present.

I am spend a lot of time with the documentation, foroms etc. any help will be appropriate.

Thanks 

Hi,

I have a container with 2 charts that are displayed based on a specific condition. At any given time, only one chart will be shown.
The first chart shows income vs expenses, shows the last 3 months based on the maximum date.
The second chart shows income vs forecasted income, the data displaying according to the selected period.
Both charts use the same dimension - Date.
Both charts are functioning and displaying accurate data.

I trying to "merge" them and add the condition to the measures.
The problem is that when I want to display "the first chart", it shows data of the second chart and only for the current month, while the others show 0.

This is one of the measures:
If(Count(distinct YearMonth) <> 1,
     [Forecast], // chart 2
     {<Date={">=$(v3Months_StartDate)<=$(v3Months_EndDate)"}, Year=, Quarter=, MonthID=>} [Expenses] // chart 1
) / 1000000

The condition refers to the number of selected months. Even though one month is selected (count(distinct YearMonth) = 1), the forecast is displaying instead of the expenses.
Why is this happening?

I would appreciate your help.
Thanks.

Dear all,

After upgrading my Talend studio version (to R2024-09)  I'm facing an issue only when I deploy a microservices to expose an API.

My API return a 500 error with this message : org/talend/transform/runtime/common/MapExecutor

The job run well when I'm testing it in the Studio, the issue occurs only when deployed on Talend Runtime.

Here the things I've tried:

- change my job and rewrite the tHmap

- upgrade Runtime and Studio to version R2024-10

- download last valid commit, import to Studio and deploy

Ofc talend-data-mapper and talend-data-mapper-dependencies are installed on Talend Runtime.

My last chance is to rewrite the job to avoid using tHmap...

Is someone have encountered this kind of issue ?

Dear All,

I have Table1 with InvoiceId, which I have to match with Id, TransId and PaymentId respectively in Table2. If InvoiceId from Table1 match with any one of these 3 columns, then show status as Matched. Else show not matched in a table. Please suggest. 

Hi,

I have a sales table with products sold on different dates and a budget table with budget amounts (month wise) for all the products for 12 months (Apr'24-Mar'25).

I have made an association between both the tables by creating a composite key using product_code, monthyear and Region fields.

In front-end, when I click on ytd button, the sales amount is showing correctly while the Budget is only reflecting of those products of which sale has happened in sales table. But I want to also include budget of those products for which sale has not happened.

Hello Qlik Community,

Is there any information about adding Alignment (to left or to right) option to object Variable input from Qlik Dashboard Bundle? This object has only one option and always aligned to left.

In many of my apps I need aligning to right.

I'm trying to place the object and to adjust it to other objects so it looks good but still it's not always placed well enought.

Thanks 

Miriam

Dear all, I have a table with general ledger movements, and I want a bar chart showing the sum of these amounts per month/year.

It's cumulative data, so the bar chart should show e.g. jan/2021 - feb/2021 - mar/2021 whereby the amount in each month is cumulative for the month in question and all previous months.

Below sample table of my data, with the column Desired Outcome what needs be shown in the bar chart.

This is the formula I tried, with no succes.

Can somebody help please.

Many thanks,
Paul