Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Welcome to
Qlik Community!
Recent Discussions
-
Change color scheme (by measure)
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? thank... Show MoreHello 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!!!
-
Getting error of ODBC drive-MSSQL as a target
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,... Show MoreHi 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
-
Use a variable with Dimension of Pivot Table
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 va... Show MoreHello
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
-
Get Max(valid_from) if valid_from <= today
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 some... Show MoreHello,
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 -
Data loading fails for License Monitor app after the upgrade to version Feb 2024
hello All, Hello All, Does anyone facing the dataloading issues with license monitor app in qlik sense? License app error: I/O error The ... Show Morehello All,
Hello All,
Does anyone facing the dataloading issues with license monitor app in qlik sense?
License app error:
I/O errorThe error occurred here:LogContent: NoConcatenate Load * FROM lib://ServerLogFolder/governanceLicenseLog_7.19.0_file.qvd (qvd) WHERE LogTimeStamp >= '2023-04-23'ThanksVamsi -
Sugestão de Melhoria para mudar a cor da linha de total no gráfico de pivot tabl...
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... Show MoreOlá!
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.
-
How to set a different background color based on value comparison with the row a...
in Qlikview please: For example, if the value in the 2nd row is lower than in the row above to be colored in green. Thank you -
ServiceNow data connection issue
HiI'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... Show MoreHi
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. -
Can't attach report to sendgrid in automation
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 ... Show MoreI'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:
message:The attachment content is required.field:attachments.0.contenthelp:As attachment I put the output of the generate report block.I don't understand how can I solve this -
Initial Data Load Too Large - alternatives???
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 histo... Show MoreI'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?
Lots of Qlik Talend Data Integration Sessions!
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.
Qlik Community How To's
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Do More with Qlik - Delivering Real-Time, Analytics-Ready Data
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.
Customer Story
Qlik Data Integration & Qlik Replicate story
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.
Customer Story
Building a Collaborative Analytics Space
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.
Location and Language Groups
Choose a Group
Join one of our Location and Language groups. Find one that suits you today!
Healthcare User Group
Healthcare User Group
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Japan Group
Japan
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Brasil Group
Brazil
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Blogs
Community News
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!