Hi, All

We have a prospect who wants to replicate data from SAP HANA Enterprise Colud(HEC) to Azure Synapse.

Does QR support SAP HEC as a source endpoint?

Best Regards,

Keishi Miyachi

We are running Qlik Sense Enterprise on Windows August 2022. I am trying to configure a new connection to Office 365 Sharepoint but getting the following error message:

Error verifying: The remote server returned an error: (407) Proxy Authentication Required.

This error occurs after I hit verify of the authentication code.

Does anyone know where I can enter the proxy details? Where can I find logs?

I assume it may have to be entered in this config file but cannot find details on it.

QvWebStorageProviderConnectorPackage.exe.config

Any assistance appreciated.

Hey, so I'm new to Qlik and attempting to create a column that I just can't get working.

I need to take the average age of "Customers" but only if they are < 100, >= 0, and their name contains the letters "P", "B", or "D'.

I've of course changed some details for confidentiality, but the methodology is the same. I've also tried to use if statements and set analysis to achieve this, but was successful with neither.

So far my code is as follows, but I don't know how to combine the two expressions into one:

#Outputs the avg of all Age values that are between [0,100)

avg(if(Age<100 and Age>=0, Age))

#Outputs all Name values that contain P, B, or D

{<Name={"P*", "B*", "D*"}>} Name

If anyone knows how to combine these two expressions into one column, help would be greatly appreciated.

Thank you

Hello, I have the following two tables and I would like to join them together. Table 1 has general data about a person and Table 2 has the thresholds of the data. Would appreciate any advice or what the best way to join these table together so I can develop some box and whisker plots based on the data. Thank you!

Table 1:

Table 2:

Requirement to show up current and archival data in two different tabs but all the tabs having left side common filter for program and other key filters. Since i do have different table for current and archival , I populate the data based on the attributes present in the table.

tab_current.qvd

[progam]

[att2]

[att3_stat]

[snapid] - * current having stats only for one snap id

tab_archive.qvd

[program_arc]

[att2_arc]

[att3_stat_arc]

[snapid_arc] - * archival having stats for olders snapids

When user picks up the filter for program in the left side filter in one tab, it has to be applied all the tabs including archival tab. since these are 2 different table, its not having any relationship. How can i achieve make a relationship with archival and current table. This is an existing application. Currently there are 5 tabs which show up current data up and running and 6th tab we are creating now to show up only archival data.

Hi,

I want to load max file data from the folder.

How to identify the max file from folder?

Example: input

File01.01.2022 to 02.02.2022

File01.01.2022 to 03.02.2022

File01.01.2022 to 04.02.2022 -> only this file data need to be upload.

File02.01.2022 to 02.02.2022

File02.01.2022 to 03.02.2022 -> only this file data need to be upload.

Example: output

File01.01.2022 to 04.02.2022

File02.01.2022 to 03.02.2022

Hi,

I did a domain name change for a Qlik Application. All applications are working fine. But the app images appears as broken images. See attached image Image1.

Before the Domain Name Change the images appeared fine. During domain name change, service accounts, host name, repository connection strings and active directory changes were made. The application is working fine in the new domain except for the broken image issue. It is not feasible to reload image for all the applications.

Additional Information:

1. The application architecture consists of :

-one central node

-three rim nodes - a proxy node, an application development node and an Application Development Proxy Node.

2. Changing the thumbnail to another thumbnail from the default folder works. The image appears without any error.

3. In QMC, in Service Cluster tab, QVD Encryption is seleted.

4. One of the images displayed as broken image is FundFlow.jpg. The advanced properties of this file is showed in Image6. The red boxes show the selection made. In this image, ‘svc_qs_prd@1’ is the old service account of the old domain. I am unable to add the new Domain's new service account to this user list.

Fixes tried:

1. Update repository.exe.congif file by adding the key “SharedContentEnable” = True and changing key “UseSecurityCacheForSharedContent” to True. And restarting Reposirory services.
2. The image files reside in AppCotent folder inside QS_Folder. I have assigned access rights to the new service account for accessing these folders. The new service account is already added to the Qlik admin group.
3. I tried few things related to the QVD Encryption and Certificates in MMC. But I didnt get the correct steps for a multi node environment. So the fix I tried didnt work.

Please suggest few fixes that I can try. Really appreciate any help provided. Thank you.