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.

Hello,

I have a data set of 1.3 million rows. For a lot of the visuals I require a long table so when i create a long table it produces 153 million rows. The widgets have a hard time loading that much data especially when the widget is using the long table. the long table gives me what im looking for in the visuals but the widget loading is really bad, Is there any other options that has the same functionality of the long table? 

Hello, does anybody has experience how to get a postgresql dbase connection via ssh? I have tried the 2 possibilities with and without via Direct Access gateway.I don't know what to choose. I have set up a ssh tunnel with mobaXterm. But I dont' get the connection to work. If I choose connection via Direct Access gateway I do not see the ssh tunnel 

Dear gurus 

There are so many similar posts in here but try to understand it may takes some time. Hence i decide to post it here using my table.

I have 2 tables - Staff and Form_Submission. Both table contains column 'Name' and 'UserIds'

In the load editor how am i suppose to write the script so that i want to know which staff in table Staff has never submit a form. I saw lots of example using Not Exist. Just hope that someone can help me by using my scenario here . TQ ! 

Hi Community,

I'm currently working with Oracle 19c as a source, and I've some tables without primary keys. Need to configure a task for a full load with Change Data Capture (CDC). How should I proceed in managing the absence of primary keys in this scenario? Your guidance on handling this situation would be greatly appreciated.

Regards,

Pranita 

Hello Everyone, I am new to Qlick and use trial version since yesterday. Following tutorial, it is requested to select "auto ML experiment" from the "Add New" drop down menu. But, This field is missing. I am wondering whether this is because I am using a trial version of Qlick...?

Does someone know about it ?

Thank you for your help

Hi all,

i have the following two tables:

Contracts:

Risks:

I am seeking a way to transform the two table into one table with the following structure:

Result:

Of course the Contract table contains multiple ContractIDs with different periods. I am aiming for a result table that contains for every given Valid_From / Valid_To the information whether any of the possible risks is included.

Thanks in advance for some help here!