Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I want to change the default color scheme to one I found online... (when i select to color by measures)
how can i do that?
thanks!!!
Hello,
I have a price list with a “valid from” date.
I always want to load the current price in the load script.
How can I do that? I thought maybe something similar to what was written in the title.
Can you help me?
Price | valid from |
10,00 | 01.01.2024 |
15,00 | 15.03.2024 |
12,00 | 01.04.2024 |
18,00 | 01.05.2024 |
Hi Team,
We are using MSSQL as a target. But getting error regarding ODBC drive which is already installed on replicate machine
Error:
SYS-E-HTTPFAIL, Cannot connect to sql server.
SYS,General_Exception,Cannot connect to sql server , sqlstate:08001 NativeError:-2146893016 Message:[Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: The received certificate has expired.
Task Name replication task encountered the following error:
Creating Metadata Manager's utility components failed Cannot create the target utility component failed while preparing stream component 'Task Name'.
Cannot connect to SQL Serv
RetCode: SQL_ERRO SqlState:08001 NativeError:- 2146893022 Message:[Microsoft][ODBC Driver 18 for SQL Server]SSL Provider:The target principal name is incorrect.
Regards,
Megha
Hello
I need some help 😉
I have dimension AA with values 'one' and 'two'
I have another dimension BB with values 'red' and 'green'
I have several variables:
one_red = 1, one_green=2, two_red=3, two_green=4
how can I build my formula so that when looping through the table, each cell in the table is the right combination?
Pivot table:
red | green
one 1 2
two 3 4
I tried : $(=Only(AA)) & '_' & $(=Only(BB)) right but not evaluated as a varible 😞
Any help will be welcome... Thank's in advance
hello All,
Hello All,
Does anyone facing the dataloading issues with license monitor app in qlik sense?
License app error:
Olá!
Gostaria de solicitar a melhoria do gráfico de pivot table para termos a opção de escolher a cor da linha de total baseado em um critério/expressão.
Hi
I'm trying to connect ServiceNow data in Qlik cloud,
I was able to connect to ServiceNow instance I see tables but when I click on any of them to see details and pick columns there is nothing but a spinning circle and an error about Qlik Sense error.
I'm new to automation stuff, I have a table in a sheet of an analysis that I need to send via email.
My automation is quite simple:
Create Report
Add sheet to report (that is the sheet where the table is built)
Generate report.
Send mail.
Now, I'm not able to attach the generated report to the email. First I've tried with the standard "send mail" block, but it was throwing an error due to authentication. Then I moved to Outlook 365 send mail but It still does not support attachement.
My final choice was the sendGrid module, since I have a sendGrid account. The email is working just fine, i can send mails with text from the automation. The problem is when I attach the generated report. It throws 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?
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!