We have created a solution to follow up sales. In the solution we chose a year and one or more months (master dimension). We monitor new customers, lost customers, customers with sales up and customers with sales down between the chosen period and the same period previous year.

All is working except "Lost customers" where we don't have sales (transactions) this year, only pervious year.

In the solution we have created master measures for the calculations with dynamic timeframes, but we struggle with the lost customers. The master measures is used in aggr functions for incorporation three dimensions.

We belive the problem is with the set expressions in the master measures we have crated. We have attached the qvf file which hopefully explains everything.

To all you experts - is there a solution for this?

Hello,

I'm looking for solution to add source from Network drive in Qlik Cloud. how we can achieve this? also how we can add Teradata as a source in qlik cloud as I'm getting error 'The Teradata server can't currently be reached over this network'.

I'm researching if QLIK replicate can be configured to send messages to another topic called "DLQ" once maximum number of retries has been reached. Can you help me to reply this? 

If not, what happen when maximum number of retries has been reached?

Thanks

Hi Everyone,

We have two scheduler nodes (S.Node 1 and S.Node2). Due to security reasons, we are trying to trigger couple of batch files in command prompt in S.Node1 only.  But Qlik sometimes assign the S.Node2 directly due to which the batch files are failing. Currently we are simply trying to pass local path of the batch file in the "Path Section".

It would be great if you can tell how we can acheive load balancing in this case? Or do we have to tweak the parameters in the External Program tasks. 

Regards,

Hi team , 

I had complied a UDF and generated dll and .so file . when I followed the steps from Document , i couldn’t  see my UDF in qlik under expression builder>>functions>>UDF .

need some help on this . please let me know if additional details needed 

followed this . 
https://help.qlik.com/en-US/replicate/November2023/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/user_defined_transformations.htm#:~:text=the%20Expression%20Builder-,User%2Ddefined%20transformations,%3CINSTALL_DIR%3E%5Caddons%5Csamples%5CMyTransformation,-Information%20note

I have this situation that I have few schemas with the same table names in every schemas and when I am adding these tables names are changed to table_name_1 and it is replicating with the same name with "_1" which is different name like in the source. I would like to handle it somehow. In old qlik every table was represanted like schema.table_name and it was not any issue when few schemas had the same table names.

Hi,

we are moving to Qlik SaaS and want to connect to a third party oracle (cloud) Database.

Is it required to do this via the direct access gateway connector? Or if the 'oracle' connector can be used, does it need to be an Public IP adress?

All feedback is appreciated . 

Hi All,
I have data like below

I want get maximum month, previous maximum month and previous to previous month example like below
For name HGI, months like below
maximum month = Jun 2023, previous maximum month = 6/8/2022, previous to previous month = 5/29/1999

I am creating a table with Name, reporting month as Aggr(Max(reporting month), Name) and expressions like below are 
1st expression :  

(Sum({<reporting_month={"$(vMaxmonth)"}>}Amount) - Sum({<reporting_month={"$(vPrevMonth)"}>}Amount)) /

Sum({<reporting_month={"$(vPrevMonth)"}>}Amount)

2nd expression : 

(Sum({<reporting_month={"$(vPrevMonth)"}>}Amount) - Sum({<reporting_month={"$(vPrev3rdvalue)"}>}Amount)) /

Sum({<reporting_month={"$(vPrev3rdvalue)"}>}Amount)

Variable are like below 
 

See below able

For HGI it is showing 840369, same way in 2nd expression it is suppose to show 8051165775.05686 but is showing empty. seems have an issue with expression while fetching 2nd previous record.

But it is not  working as expected , please help me someone to achieve this
thanks in advance

Regards,

Saritha

Hi,

I am using Qlik sense Enterprise on windows of qlik sense server 14.129.6(May 2023).

I need to store the QVD files in S3 bucket. but i am getting error as can't open file...

while making connection to S3, i am not getting option of SSE header(which i get to know while searching the error).

so is the issue related to qlik sense version or what would be the reason?

Thank you!