Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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:
ContractID | Valid_From | Valid_To | Risk |
123 | 2003-01-01 | 2003-12-31 | A |
123 | 2003-01-01 | 2003-12-31 | B |
123 | 2003-01-01 | 2003-12-31 | C |
123 | 2004-01-01 | 2004-12-31 | B |
123 | 2004-01-01 | 2004-12-31 | E |
Risks:
Risk | Risk_Name |
A | Risk_A |
B | Risk_B |
C | Risk_C |
D | Risk_D |
E | Risk_E |
I am seeking a way to transform the two table into one table with the following structure:
Result:
ContractID | Valid_From | Valid_To | Has_Risk_A | Has_Risk_B | Has_Risk_C | Has_Risk_D | Has_Risk_E |
123 | 2003-01-01 | 2003-12-31 | Yes | Yes | Yes | No | No |
123 | 2004-01-01 | 2004-12-31 | No | No | No | Yes | Yes |
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!
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Join us on April 24th at 10 AM ET for the next Do More with Qlik webinar focusing on Qlik’s Data Integration & Quality solutions.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!