Hi all

I've been struggling with this and hoping I could get some help. I have a pivot table with a field called Spec in the Row. The column area has 2 fields, region and area. I have turned on the Show totals toggle for the region column and would like to have all background color based on that totals. 

As seen in the attached, I have turned on the "Show totals" toggle on the region column and can see that it is 1.46 for the first item in the row. I'd like the background color of the values in that row to be red if greater than 1.46 and green if lesser. And likewise, apply this for all rows.

Appreciate any help with this.

Hi, my Qlik license expires on June 28th, 2024. So, if I get the offline SLK before the expiry date, can I apply the key ahead of time? e.g. if I get the key on June 21st, can I apply the Key on June 21st itself to extend the license to June 2025 rather than waiting for June 28?  Thanks.

I created a straight table (the new version under Custom Objects - Qlik Visualization). After the cloud app is published, my end users noticed an option that states "Adjust Column Size" when the end user clicks on the column header. This option does nothing.

I verified the non-behavior.  

Am I missing something here?

Hi all,

I want to calculate turnover rate per month and here is the formula:

Current month's turnover

/

[(Current month's end headcount + Last month's end headcount) / 2]

However, I need do display the result in a table and line chart.

Due to the Monthly restriction, the expression seems not as easy as I expected.

I don't have a master calendar and I'd like to ask for help. How can I achieve this?

For example, in May, the denominator should be (119+120)/2;

in April, the denominator should be (120+118)/2

I cannot use the following expression because it causes a wrong result. It actually add the number per month.

For instance, in May it results in (119+0)/2;

in April, it shows (120+120)/2, which is not what I want.

(
(
(count(distinct {1<%headcount_key={"*"}, [is_seconded]={"0"}, [section_code] -= {"VAC", "CPP"}, [date_month]={">=$(=MonthStart(vStartDate))<=$(=MonthEnd(vEndDate))"}>} [dim_ppl_employee_sk]))
+
(count(distinct {1<%headcount_key={"*"}, [is_seconded]={"0"}, [section_code] -= {"VAC", "CPP"}, [date_month]={">=$(=MonthStart(vLastStartDate))<=$(=MonthEnd(vLastEndDate))"}>} [dim_ppl_employee_sk]))
)
/2
)

Thanks for any advice.

Hi Team, 

we were facing issues while loading the XML table from Db2 z/OS to RDS Postgres using Attunity (Qlik Replicate). The tables have around 2Million rows, and the max record length is of 47MB.  We are receiving below error when we try the load: 

RetCode: SQL_ERROR  SqlState: 40003 NativeError: 
-1224 Message: [IBM][CLI Driver] SQL1224N  
The database manager is not able to accept new requests,
has terminated all requests in progress, 
or has terminated the specified request because of an error or a forced interrupt.  SQLSTATE=55032

=> We tried to break the data into chunks like in 20 different tables each table has around 13k rows. but still we are receiving the same error and we tried to option in the tool like "ALLOW UNLIMITED LOB" and "Limit LOB size to (KB) to 50MB" and breaking still further will be tedious task what if the table has millions of data more? We wanted to understand where the actual issue is? and is there any other option we need to consider for loading XML/LOB data .Kindly review above issue and let us know if further info is required from my end.

Some more info :

Datatype  : XML 

Source : DB2 zOS V12 and Target : Postgres RDS 

Hi Qlik Support,

Is there a recommendation on how to patch missing data in Qlik Replicate?

We have a scenario where data is missing from the target for a particular time frame (e.g. 6th June 10:35AM - 11:00AM). This is because when restarting the task from a timestamp, the incorrect timestamp was used, which in turn caused source data to be skipped.

Is it possible to only replay the changes in a specified time frame? And if so, is there a best practice method or considerations that need to be taken into account when doing so?

Apologies if this idea has already been addressed in a previous community post.

Thanks,
Nak

Hello, 

i need help for a substitution of values from one field if another field is empty (in the data load editor section):

Here is an example in hope my request is more understandable:

Field1 Field2 Proxy

-         534     534 

123    123      123

234    234     234

-         567     567

345      -        345

So basically the proxy field should contain the values of either of the field1 or field2 values.

Any ideas on how to solve this?

Dear all,

I try to request Audit API with filters but it doesn't work.

When I request with this query, it works well:

https://mytenant.eu.qlikcloud.com/api/v1/audits

But when I try to add filter, 

https://mytenant.eu.qlikcloud.com/api/v1/audits?filter=(eventTime ge %222024-06-01T00:00:00.000Z%22)&limit=100

Do you know how I can use filter with Audit API ?

Thanks !

Sum(
if(recurring_month = 12 AND (status_id = 'future_payment' OR status_id = 'success'),
amount
)
)
* vNewRaise * vRenewalRate +
(sum({<FlagDate = {'due_date'}>} amount) )
- (sum({<status_id = {'cancelled'}>} amount) ) 

I have an expression like this lemme give the example of it that version of the code is adding fourth and the six columns value and find the value at the seventh column in the same row. My aim is to add fourth column one below value to the same one and I want to put the result at the same place at seventh column. To make it more clear, 416,223 + 2,951,106 = 3,367,229 but I want it to do 286,433 + 2,951,106 = 3,237,539 the miss calculation happens bc of in my opinion but help is appreciated!!

 Sum(
if(recurring_month = 12 AND (status_id = 'future_payment' OR status_id = 'success'),
amount
)
)
* vNewRaise * vRenewalRate  

Hello everyone.

How do I extract a string content from a column into multiple columns?

I have this:

And I want to turn it into this:

Mind you, the original column "TEAMS" may have a different number of values. So the Job has to be dynamic to create as many columns as the values in the original "TEAMS" column.
The "-" character is the values separator.

I just can't seem to get over this hurdle.
Can anyone please help me?

Thank you so much,

Rui