Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Bom dia pessoal,
Sabem se existe uma forma de fazer com que um qvw seja automaticamente carregado todos os dias pela manhã? Como se fosse simular um "clique" do cliente no qvw, via Access Point?
O motivo é que tenho um dashboard que demora muito tempo para ser carregado no browser, e se fosse possível deixar ele previamente carregado, quando o cliente fosse acessar o dashboard, ele abriria mais rápido na tela.
Desde já agradeço a ajuda!
This is the sheet that I created in Tableau. How can I replicate it in QlikView? The values are the sum of sales (in the block). I have tried creating a pivot table, but I can't get months as columns; all months are in one column instead of different columns. Thanks in advance.
We have created a ticket with this question, and they suggested asking this question in the Community.
We would like to send a notification (email) when we get bad data.
Source target Oracle, data type character.
Endpoint target Confluent v7 Kafka Avro primitive.
Background.
We have an older app running that uses Oracle that has date columns defined as char(8). This means users can (and do) enter invalid dates. We transform the character to datetime, and can test using Sqlite for a valid date, but cannot send an email from Sqlite, or from Replicate. When the invalid date is sent to Kafka it shows up as 9999-12-31 23:59 so it's no longer valid. We haven't found an easy way in our data stream to capture the date. We have looked at the user defined function in the expression builder, but currently do not have a C programmer on in our group.
Question
Is there a way to send a notification (email) from Qlik on bad data?
Tengo una tabla con columnas creadas por condicionales, y quiero mostrar un KPI que me sume todos los unos que hay en la tabla de las dos columnas que señalo.
- count
- Real vs Requested
Como vemos el sumatorio de la columna da 4 y el Kpi me esta dando 1, por lo que no entiendo porque me da distinto si la función que he puesto en KPI es un agregate de esa columna, (adjunto foto)
Esta es la función del KPI de Real vs Requested
Hello, I'd like to use Aspose.total or Aspose.words in a talend job. Previously when we needed some third party jars (AWS secrets manager related), we downloaded the jars manually from mvnrepository.
However, in this case I don't see any jar files on the Aspose website or on mvnrepository. I only see the xml for the pom.xml. See below.
<dependency> <groupId>com.aspose</groupId> <artifactId>aspose-words</artifactId> <version>24.2</version> </dependency>
Do I need to manually insert that xml into the talend pom.xml? The tLibraryLoad component seems to assume that you have access to the physical jar file, which I don't have.
I'm a decent talend developer, but I don't have much experience with third party libraries.
During our regular scans we found some vulnerabilities on libcurl.dll (cve mentioned below), we are using the qliksense version - 14.78.23 (August 2022 patch 16).
The recommendation is to upgrade to libcurl 8.4.0. Please suggest if there are any patches available for upgrading libcurl.
CVE-2023-38545 (Heap Buffer Overflow)
CVE-2023-38546 (Cookie Injection)
If we have an application with our organisational data on Qlik SAAS Cloud, does it mean it is exposed to qlik vendor , how the security provided to our data on Qlik saas Cloud?
Hello ,
I want to create a fiscal year master calendar and I have used the below script :-
//-- Fiscal year Mastr Calendar---//
QuartersMap:
MAPPING LOAD
rowno() as Month,
'Q' & Ceil (rowno()/3) as Quarter
AUTOGENERATE (12);
Temp:
Load
min(EMLC_OK_DATE) as minDate,
max(EMLC_OK_DATE) as maxDate
Resident ZZ_FF_BUILD_DETAIL_DAILY;
Let varMinDate = Num(Peek('minDate', 0, 'Temp'));
Let varMaxDate = Num(Peek('maxDate', 0, 'Temp'));
DROP Table Temp;
TempCalendar:
LOAD
$(varMinDate) + Iterno()-1 As Num,
Date($(varMinDate) + IterNo() - 1) as TempDate
AutoGenerate 1 While $(varMinDate) + IterNo() -1 <= $(varMaxDate);
MasterCalendar:
Load
TempDate AS EMLC_OK_DATE,
week(TempDate) As RFS_Fiscal_Week,
Year(TempDate) As RFS_Fiscal_Year,
Month(TempDate) As RFS_Foscal_Month,
Day(TempDate) As Day,
// YeartoDate(TempDate)*-1 as CurYTDFlag,
//YeartoDate(TempDate,-1)*-1 as LastYTDFlag,
inyear(TempDate, Monthstart($(varMaxDate)),-1) as RC12,
date(monthstart(TempDate), 'MMM-YYYY') as RFS_Fiscal_MonthYear,
ApplyMap('QuartersMap', month(TempDate), Null()) as RFS_Fiscal_Quarter,
Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as RFS_Fiscal_WeekYear,
QuarterName(AddMonths(TempDate,3)) as RFS_Fiscal_QuarterName,
WeekDay(TempDate) as RFS_Fiscal_WeekDay
Resident TempCalendar
Order By TempDate ASC;
Drop Table TempCalendar;
exit script;
//==============================//
But I am not getting the proper output. Please see below :-
Not sure, what mistake I made in the above script. Can anyone please help me ?
Thanks in advance
Qlik Compose for Data Warehouses
Hello everyone,
in qlik sense
I have a timestamp in a string format and I need to convert it into a date and time with e specific format.
the idea is to be able to create a calendar or extracts month.week...etc from that field, which is not possible when it's a string
Hi all,
I've got this strange situation on Qlik Sense Client-Managed Aug 2023 Patch 3.
The environment consists of 5 nodes as follows:
To give power during the nightly reloads, I configured a Windows Scheduled Task that runs at 00:00 and enable (via API) a temporary load balancing rule that balance all apps (published + non published) on DEV Node also.
What is happening here is that when I enable the temporary LB rules at night, all the tasks are redirected on DEV node, no tasks runs on Central / Scheduler Nodes, ignoring any other load balancing rules (also the read-only rule for the central node). No error on engine/repository logs for Central/Failover node.
Any idea?
Thank you
Elevate your career with Connect. 15 Hands-on workshops and certifications for Data and Analytics.
Get to know these Qlik experts driving innovation and excellence in data, analytics and AI.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
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!