While creating an source end point of SAP Application in Qlik Replicate, I am getting the following error:

Note: I have added sapnwrfc.dll file in environment variables also still I am facing the same issue. Also, same issue appeared for me in QCDI.

I have a field for postal code, latitude, longitude, state and city. The latitude and longitude is based on the center of the postal codes. I want to be able to create a filter that pushes the data out to include other zip codes by their lat/lon coordinates based on whether the user selects 5, 10, 20, 25 or 50 mile radius. Is this possible in Qlik with the data I have available to me?

Source: On-Prem SQL server

Target: Azure SQL server

We are copying 196 tables from source to target. For whole night it was running fine. Full load and Change processing was perfect over a night.

Suddenly we encountered this error.

Hi, I'm trying to connect Office 365 Sharepoint in Qlik Sense. Below are the steps performed. 

1. Creating a new data connection. 

2. Choosing the Office 365 SharePoint connector, and mention the base URL and choose the "select Account" prompt. 

3. Then its asked for authenticate, the code was generated. and copied that code. Pasted in the respective tab place. 

After that I'm facing the below error. 

" Error Verifying: A connection attempt failed because the connected party did not properly respond after a period of time or established connection failed because connected host failed to respond 40.126.53.18:443"

Note: The IP getting changed whenever I tried. 

Please suggest. 

Hi ,

I have two dimesion  and we have used secondary dimensionality in measure to create a pivot table as shown

now based on selecting any dimension user wants the measure to be sorted in descending order please se the measure below.

 we have used dimensionality concept in our expression as shown below

Please let me know how to sort all measures if we select any one  dimension

thanks,

Suresh 

Hi All,

I want to be able to report by an automated method (eg. Splunk/QEM API) when a QR tasks is changed on our Prod environment as a part of a regulatory requirement. 

I tried looking in the QEM logs and it has something basic like: 

76 2024-04-19 09:18:41 [Collector ] [INFO ] Executing ImportReplicateTask.

But no other details of what tasks and by whom.

Is there another method to audit changes to Qlik tasks?

Hello i am working on a task to improve the current load script for easy readability

we are loading the last 3 financial year files the files are named as follows

eg: Filename_year_2021

Let vFinPayCurrent = $(vMfinyr)&$(vMfinyr)+1; //Current Finpay
Let vFinPayLastYear = $(vMfinyr)-1&$(vMfinyr); //Last financial year
Let vFinPay2YrsAgo = $(vMfinyr)-2&$(vMfinyr)-1; //2 Financial Years ago

For loop to concat all these together,

Set vfilelist ='vFinPayCurrent','vFinPayLastYear','vFinPay2YrsAgo';
for each var in vfilelist
MyTable:
load *
FROM [$(vG.QVDPath)/Filename_year_$(var).qvd]
Next var

CURRENT Approach:

mytable:

load * from 

[$(vG.QVDPath)/Filename_year_$(vFinPayCurrent ).qvd]

concatenate

load * from 

[$(vG.QVDPath)/Filename_year_$(vFinPayLastYear ).qvd]

concatenate

load * from 

[$(vG.QVDPath)/Filename_year_$(vFinPay2YrsAgo ).qvd]

Thanks in advance