Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I'm new to Qlik sense -
I'm a new Qlik Sense business analysis and I'm building a Qlik Sense app for analysis to replace excel VBA code to pull historical purchases for one or more items - IT will no longer support the excel VBA :(. My organization is large and the total number of records in my PO data warehouse exceeds over well over 100M records. Requirement is that I use Qlik Sense to pull the same data as the excel VBA code.
My only search criteria is item number. There is no limit to time, geography or entity.
When i build the SQL to the data warehouse, I write the SQL in the Data Load Editor and it pulls all PO data... over 100M+ records. Couple of challenges:
1/ When Qlik Sense users attempt to use the app, they often run into Out of Memory errors.
2/ When the App works, it takes more than 20min for the sheet to display and users can enter item numbers.
Questions:
1/ is this expected behavior for Qlik Sense to frequently result in errors for such large data sets? I filtered the data sets to return about 50M records and it still results in error, sometimes.
2/ Is there a way in Qlik Sense to allow users to enter the item numbers BEFORE the initial data load and have only the required item number PO history be pulled?
3/ I tried building a QVD file but it takes 20 min to load the data then another 30 minutes to index. Waiting nearly an hour to run a report doesn't seem to make sense.
What other options, if any, do i have in Qlik Sense to limit the initial data load?
With the latest version of Qlik Cloud, I am unable to get to the Data Model Viewer. Following the information on permissions, I tried the following, but nothing can show.
Even when trying to directly go to the Data Model Viewer from the URL https://my-tenant.us.qlikcloud.com/datamodelviewer/app/{appId}, I get the following.
Did something change recently about accessing the Data Model Viewer?
Hello everyone,
We have 2 QlikSense servers in our internal infrastructure and we want to expose these 2 servers externally, through Nginx.
We would like to be able to access these servers via ourdomain.com/qliksense1 and ourdomain.com/qliksense2.
Is it possible to configure Nginx to allow this?
Furthermore, we also require virtual proxies for some of our custom apps and we would like to be able to access the virtual proxy via ourdomain.com/qliksense1/virtualproxy and ourdomain.com/qliksense2/virtualproxy.
Is this possible?
Thank you!
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?
Hello ,
I have a pivot table with:
Dimension: Matricule , Nom
Column: Type( Frais or Gain)
Mesures : GH,GM,SIP
i want to change the name of the mesures based on the value of the column "Type"
Exemple If Type='Gain' and mesure = GH then the mesure name will be "Gain GH"
I used this formula as a name of the mesure : if(wildmatch(Type,'Gain'),'Gain GH', 'Frais GH') but it's not working it gives the same value everywhere
Is there a way to do this ?
Thank you in advance.
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.
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!