I have a loop that pulls a list of ids and executes a tRest api for each id.  This works until it doesn't.

When it works it brings back json with it's Body and ERROR_CODE columns.  From there I can troubleshoot any data.  But occasionally it brings back a random xml that I can't even capture.  It fails the trest component with a error...

"Too many "Content-Type" header values: "[text/xml: charset="utf-8", null]"

Is there a way that when the api blows up, I can do a resume next or any continue to the next iteration?

Hi,

I have recenlty created the date field using Dual to show the dates in descending order in filter pane and selection tool both and its working well.

Dual(Date1,-1*Date1)  giving result 2025/10

While i tried to incorporate this changes into my existing dates i.e Date which is also holding dates in 2025/10 format but in Text format its not working.

Let say i wanted to show YTD and Rolling 12 months data when clicking on action button.Its wokring fine and getting associated and selecting with green color.

R12 Logic:

=year(addmonths(TODAY(),-2))&'/'&if(num(month(addmonths(TODAY(),-2)))<10,'0','')&num(month(addmonths(TODAY(),-2)))&';' &year(addmonths(TODAY(),-3))&'/'&if(num(month(addmonths(TODAY(),-3)))<10,'0','')&num(month(addmonths(TODAY(),-3)))&';' &year(addmonths(TODAY(),-4))&'/'&if(num(month(addmonths(TODAY(),-4)))<10,'0','')&num(month(addmonths(TODAY(),-4)))&';' &year(addmonths(TODAY(),-5))&'/'&if(num(month(addmonths(TODAY(),-5)))<10,'0','')&num(month(addmonths(TODAY(),-5)))&';' &year(addmonths(TODAY(),-6))&'/'&if(num(month(addmonths(TODAY(),-6)))<10,'0','')&num(month(addmonths(TODAY(),-6)))&';' &year(addmonths(TODAY(),-7))&'/'&if(num(month(addmonths(TODAY(),-7)))<10,'0','')&num(month(addmonths(TODAY(),-7)))&';' &year(addmonths(TODAY(),-8))&'/'&if(num(month(addmonths(TODAY(),-8)))<10,'0','')&num(month(addmonths(TODAY(),-8)))&';' &year(addmonths(TODAY(),-9))&'/'&if(num(month(addmonths(TODAY(),-9)))<10,'0','')&num(month(addmonths(TODAY(),-9)))&';' &year(addmonths(TODAY(),-10))&'/'&if(num(month(addmonths(TODAY(),-10)))<10,'0','')&num(month(addmonths(TODAY(),-10)))&';' &year(addmonths(TODAY(),-11))&'/'&if(num(month(addmonths(TODAY(),-11)))<10,'0','')&num(month(addmonths(TODAY(),-11)))&';' &year(addmonths(TODAY(),-12))&'/'&if(num(month(addmonths(TODAY(),-12)))<10,'0','')&num(month(addmonths(TODAY(),-12)))&';' &year(addmonths(TODAY(),-13))&'/'&if(num(month(addmonths(TODAY(),-13)))<10,'0','')&num(month(addmonths(TODAY(),-13)))

E.g 2025/10;2025/09;2025/08;...2024/11

The problem statement is when clicking on R12 button my new Date1 which got created using Dual is not getting selected with green color although its getting associated as per Qlik associative nature.

I tried many approache to get this link but no luck.

HI Team,
Currently Qlik replicate child task is enabled with Stored changes only for CDC processing.
We are keeping global policy from Apply conflicts and using Upsert mode(for duplicates and inserts not found).Can we change this to Task policy for Stored changes.
Incase Global handling policy is needed, then still do we need upsert mode to be existed.
Will it cause delay(latency) while writing entries to attrep_changes table in Databricks.

Currently we are seeing latency while writing cdc data through Insert/SQL merge queries from Qlik->to s3->Databricks.
From error handling perspective between qlik-> databricks delta, Please let us know the recommendation for Apply Conflicts in this case.

Source:MS Sql server(MS-CDC)

Target:Databricks Delta

Thanks,

Sudarsan K

I am setting up an SMTP Email Provider in a Qlik Cloud Academic account. The SMTP provider is Outlook.com and it uses TLS encryption. However, Qlik Administration Settings gives an error when I Save if Security is set to StartTLS or SSL/TLS:

Email provider is not working as expected:

* Unable to verify provider configuration.

If I change Security to None then Save works. But clicking Test E-mail returns an error after a few seconds:

There was a problem sending your email. Please review your settings.

I have verified the SMTP settings with Outlook.com as well as the email username and password. Is there any known issue using Outlook.com?

hi all,

I have Source as oracle and target as Databricks Delta tables on GCP. Here Qlik not support for the Cloud native function as Data enrichment function in the 2024 and 2025 Version.

So i added one column manual at the target DBRX end as Current_timestamp.

ALTER TABLE vvv ADD COLUMN audit_created_datetime TIMESTAMP;
ALTER TABLE vvv SET TBLPROPERTIES('delta.feature.allowColumnDefaults' = 'supported');
ALTER TABLE vvv alter column audit_created_datetime set default current_timestamp();

But here when i get full load using Qlik replicate i need Current timestamp and when ever i got INSERT i need the col audit_Created_Datetime as current_timestamp values.

Even i add as Replace column value as audit_Created_datetime as datetime('now', 'UTC'). i got NULL in the column kindly give the solution.

Good morning all,

I was looking for some help with this problem I am having with a parametrized variable. 

In the editor I define the following variables:

Set vFormatBigNum = Dual(Num($1/ Pow(10, 3 * Div(Log10(fabs($1)),3)),'#.##0,0') & '' & Pick(Div(Log10(fabs($1)), 3),'k','M','B','T'), $1);
SET vNumFormatKPI = if($1 = 'BIGMONEY', '€' & $(vFormatBigNum($2))
          , if($1 = 'MONEY', '€' & num($2, '#.##0,0')
            , if($1 = 'BIGINTEGER', $(vFormatBigNum($2))
                        , if($1 = 'INTEGER', num($2, '#.##0')
                              , if($1 = 'DECIMAL', num($2, '#.##0,0')
                                  , if($1 = 'PERCENTAGE', num($2, '#.##0,00%')
                                      , $2))))));

Which I than use in the sheet for a KPI value:

 

How I solve this issue?

Hi ,

I am Currently using Nprinting desktop designer (24.4.10.0), in which vertical band is not available.

Please refer the attached image for reference.

Kindly help me to identify this issue.