Ask a Question

Welcome to
Qlik Community!

Recent Discussions

Sort By:

Comparar hora en rango

Hola, estoy intentando crear un rango cada 15 minutos, donde recibo una hora y valido si es mayor a desde y menor a hasta la función definitivamente n... Show More

Hola, estoy intentando crear un rango cada 15 minutos, donde recibo una hora y valido si es mayor a desde y menor a hasta

la función definitivamente no está funcionando

a continuación un ejemplo de como debiese funcionar

Hora_RangoHora	Desde	Hasta	if(Hora_RangoHora>=Desde,1,0)	if(Hora_RangoHora<=Hasta,1,0)
00:00:48	00:00:00	00:14:59	1	1
00:00:48	00:15:00	00:29:59	0	1
00:00:48	00:30:00	00:44:59	0	1
00:00:48	00:45:00	00:59:59	0	1
00:00:48	01:00:00	01:14:59	0	1
00:00:48	01:15:00	01:29:59	0	1
00:00:48	01:30:00	01:44:59	0	1
00:00:48	01:45:00	01:59:59	0	1
00:00:48	02:00:00	02:14:59	0	1
00:00:48	02:15:00	02:29:59	0	1
00:00:48	02:30:00	02:44:59	0	1
00:00:48	02:45:00	02:59:59	0	1
00:00:48	03:00:00	03:14:59	0	1
00:00:48	03:15:00	03:29:59	0	1
00:00:48	03:30:00	03:44:59	0	1
00:00:48	03:45:00	03:59:59	0	1
00:00:48	04:00:00	04:14:59	0	1
00:00:48	04:15:00	04:29:59	0	1
00:00:48	04:30:00	04:44:59	0	1
00:00:48	04:45:00	04:59:59	0	1
00:00:48	05:00:00	05:14:59	0	1
00:00:48	05:15:00	05:29:59	0	1
00:00:48	05:30:00	05:44:59	0	1
00:00:48	05:45:00	05:59:59	0	1
00:00:48	06:00:00	06:14:59	0	1
00:00:48	06:15:00	06:29:59	0	1
00:00:48	06:30:00	06:44:59	0	1
00:00:48	06:45:00	06:59:59	0	1
00:00:48	07:00:00	07:14:59	0	1
00:00:48	07:15:00	07:29:59	0	1
00:00:48	07:30:00	07:44:59	0	1
00:00:48	07:45:00	07:59:59	0	1
00:00:48	08:00:00	08:14:59	0	1
00:00:48	08:15:00	08:29:59	0	1
00:00:48	08:30:00	08:44:59	0	1
00:00:48	08:45:00	08:59:59	0	1
00:00:48	09:00:00	09:14:59	0	1
00:00:48	09:15:00	09:29:59	0	1
00:00:48	09:30:00	09:44:59	0	1
00:00:48	09:45:00	09:59:59	0	1
00:00:48	10:00:00	10:14:59	0	1
00:00:48	10:15:00	10:29:59	0	1
00:00:48	10:30:00	10:44:59	0	1
00:00:48	10:45:00	10:59:59	0	1
00:00:48	11:00:00	11:14:59	0	1
00:00:48	11:15:00	11:29:59	0	1
00:00:48	11:30:00	11:44:59	0	1
00:00:48	11:45:00	11:59:59	0	1
00:00:48	12:00:00	12:14:59	0	1
00:00:48	12:15:00	12:29:59	0	1
00:00:48	12:30:00	12:44:59	0	1
00:00:48	12:45:00	12:59:59	0	1
00:00:48	13:00:00	13:14:59	0	1
00:00:48	13:15:00	13:29:59	0	1
00:00:48	13:30:00	13:44:59	0	1
00:00:48	13:45:00	13:59:59	0	1
00:00:48	14:00:00	14:14:59	0	1
00:00:48	14:15:00	14:29:59	0	1
00:00:48	14:30:00	14:44:59	0	1
00:00:48	14:45:00	14:59:59	0	1
00:00:48	15:00:00	15:14:59	0	1
00:00:48	15:15:00	15:29:59	0	1
00:00:48	15:30:00	15:44:59	0	1
00:00:48	15:45:00	15:59:59	0	1
00:00:48	16:00:00	16:14:59	0	1
00:00:48	16:15:00	16:29:59	0	1
00:00:48	16:30:00	16:44:59	0	1
00:00:48	16:45:00	16:59:59	0	1
00:00:48	17:00:00	17:14:59	0	1
00:00:48	17:15:00	17:29:59	0	1
00:00:48	17:30:00	17:44:59	0	1
00:00:48	17:45:00	17:59:59	0	1
00:00:48	18:00:00	18:14:59	0	1
00:00:48	18:15:00	18:29:59	0	1
00:00:48	18:30:00	18:44:59	0	1
00:00:48	18:45:00	18:59:59	0	1
00:00:48	19:00:00	19:14:59	0	1
00:00:48	19:15:00	19:29:59	0	1
00:00:48	19:30:00	19:44:59	0	1
00:00:48	19:45:00	19:59:59	0	1
00:00:48	20:00:00	20:14:59	0	1
00:00:48	20:15:00	20:29:59	0	1
00:00:48	20:30:00	20:44:59	0	1
00:00:48	20:45:00	20:59:59	0	1
00:00:48	21:00:00	21:14:59	0	1
00:00:48	21:15:00	21:29:59	0	1
00:00:48	21:30:00	21:44:59	0	1
00:00:48	21:45:00	21:59:59	0	1
00:00:48	22:00:00	22:14:59	0	1
00:00:48	22:15:00	22:29:59	0	1
00:00:48	22:30:00	22:44:59	0	1
00:00:48	22:45:00	22:59:59	0	1
00:00:48	23:00:00	23:14:59	0	1
00:00:48	23:15:00	23:29:59	0	1
00:00:48	23:30:00	23:44:59	0	1
00:00:48	23:45:00	23:59:59	0	1

código de carga

MaestroFecha:

LOAD Distinct

ID_Fecha,

Date(Floor(ID_Fecha),'DD/MM/YYYY') as Fecha,

Year(ID_Fecha) as Año,

Month(ID_Fecha) as Mes,

Dual(Year(ID_Fecha)&'-'&Month(ID_Fecha), monthstart(ID_Fecha)) AS AñoMes,

Dual('Q'&Num(Ceil(Num(Month(ID_Fecha))/3)),Num(Ceil(NUM(Month(ID_Fecha))/3),00)) AS Quarter,

time(ID_Fecha) as Hora

Resident Consolidado;

Maestro_RangoHora_TEMP:

LOAD HoraDesde as HDesde,

HoraHasta as HHasta

FROM [lib://Aldesa:DataFiles/Maestros Aldesa Excel.xlsx]

(ooxml, embedded labels, table is [Maestro Hora]);

Maestro_RangoHora_TEMP2:

LOAD

Time(MakeDate(1,1,2024)&' '&HDesde) as Desde,

Time(MakeDate(1,1,2024)&' '&HHasta) as Hasta

Resident Maestro_RangoHora_TEMP;

Drop table Maestro_RangoHora_TEMP;

Join (Maestro_RangoHora_TEMP2) Load Distinct time(ID_Fecha)as Hora_RangoHora Resident MaestroFecha;

Maestro_RangoHora_Temp3:

LOAD Distinct Hora_RangoHora,

Desde as HoraDesde,

Hasta as HoraHasta,

IF(Hora>=HoraDesde and Hora<=HoraHasta,HoraDesde&'-'&HoraHasta,'Vacio') as RangoHorario

Resident Maestro_RangoHora_TEMP2;

Drop table Maestro_RangoHora_TEMP2;

Maestro_RangoHora:

NoConcatenate

LOAD Hora_RangoHora as Hora, HoraDesde, HoraHasta,

RangoHorario Resident Maestro_RangoHora_Temp3 Where RangoHorario<>'Vacio';

Drop table Maestro_RangoHora_Temp3;

Show Less

New to Qlik Analytics

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 More

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?
Show Less

By Voyager_RVA 2024-04-22 / 06:06 AM

10 1 237
Qlik Replicate

Full load task

Hi I had a quick question about full load, let's say if I started my task and its running for 2 hours, meanwhile any new changes that are coming on th... Show More

Hi I had a quick question about full load, let's say if I started my task and its running for 2 hours, meanwhile any new changes that are coming on that DB2 table - will those also be replicated?

Thanks
Show Less

By Preethi13 2024-04-23 / 11:49 AM

2 2 39
QlikView App Dev

newline in expression

HiI've tried everything but cant figure out how to insert a new line character... I would like to show these three fields below each other. nl doesn't... Show More
Hi
I've tried everything but cant figure out how to insert a new line character... I would like to show these three fields below each other. nl doesn't work...
```
=Maxstring(If([L1] = VarL1Out and Isnull([L2]),[HoverText])) &'. Actual: '
&Maxstring(If([L1] = VarL1Out and Isnull([L2]),[Actual])) & '. Target: '
&Maxstring(If([L1] = VarL1Out and Isnull([L2]),[Target]))
{/code]
Currently the help text looks like this:
My hovertext. Actual: 50.4. Target: 55.5
I want to be like:
My hovertext.
Actual: 50.4.
Target: 55.5</body>
```
Show Less
By alerse 2009-07-06 / 08:56 AM

13 4 40509
New to Qlik Analytics

Dont want section data to be linked to each other

I have sections in my data load script. Currently, I have two sections, and they are pulling data from entirely different tables. However, they appear... Show More

I have sections in my data load script.

Currently, I have two sections, and they are pulling data from entirely different tables. However, they appeared to be linked. When I go to the pivot, it pulls data based on a selection of the other sections.

How can I have each data pulled from their respective sections?

Also, it is slowing the application.
Show Less

By urbanfaces 2024-04-23 / 10:22 AM

2 2 45
QlikView Administration

the system how to deal the running that qlikview multiple tasks in one qvw file

Hi Guys, I just have a concern that there is a qvw exist multiple tasks. When I run those tasks at a same time the system is how to deal with this si... Show More

Hi Guys, I just have a concern that there is a qvw exist multiple tasks. When I run those tasks at a same time the system is how to deal with this situation? whether those multiple tasks are put into independent stack to run?

thanks

Show Less

By chenpeng 2024-04-10 / 12:38 AM

2 2 96
Qlik Compose for Data Warehouses

Perfomance of query with multiple joins when inserting into TSTG table _P on mig...

We recently migrated from SQL Server 2014 to SQL Server 2019. For one of the inserts in to the _P table that is labled "Inserting Top Rows into TSTG_E... Show More

We recently migrated from SQL Server 2014 to SQL Server 2019. For one of the inserts in to the _P table that is labled "Inserting Top Rows into TSTG_Entity_NAme_P for existing objects" that joins to 10 files, it is now unable to complete after 24 hours instead of 3 minutes.
Show Less

By Stewart_Harding 2024-04-23 / 06:26 AM

1 2 38
Qlik Cloud Data Integration

Criação Data Gateway Data Movement - Espaços não aparecem

Olá, tenho um servidor linux ubuntu onde pretendo instalar o data gateway data movement, consigo fazer a instalação, porém, ao tentar criar a conexão ... Show More

Olá, tenho um servidor linux ubuntu onde pretendo instalar o data gateway data movement, consigo fazer a instalação, porém, ao tentar criar a conexão com o gateway, e selecionar em data movement, ele não traz nenhum espaço para que eu possa selecionar, embora eu tenha espaços criados.

Show Less

By GuiZZao 2024-04-23 / 11:19 AM

1 2 27
Move to SaaS

Qlikview documents in SaaS

How can i upload a Qlikview document .qvw into Cloud and use it as binary load into my Qlik Sense App in Cloud.

By anuradha-bala 2024-04-23 / 08:45 AM

1 2 41
New to Qlik Analytics

Include NULL Values Handling in KPI charts in Qlik sense

Hello Everyone, I have an issue with the Set expression in KPI chart. i'm calculating the percentage in my expression i'm using Parent incident id for... Show More

Hello Everyone,

I have an issue with the Set expression in KPI chart. i'm calculating the percentage in my expression i'm using Parent incident id for this column is having Null values i want to calculate the Null values. but while calculating the t column not considering. please find the below expression

Num(sum({<Goal={'Cpi - Critical - Restore'},ID={'365'},Reported_13Month={1},[Status]={0},[Parent Incident ID]={'Null'}>}[Ticket Count])/sum({<Goal={'Cpi - Critical - Restore'},ID={'365'},Reported_13Month={1},[Parent Incident ID]={'Null()'}>}[Ticket Count]),'##.##%')

please anyone can help me on this.
Show Less

By jaswanth222 2024-04-23 / 04:29 AM

6 3 107

High Five

Meet Fabian

Our featured member for April 2024

Leaderboard

Heinvandenheuvel

Raviraj

igoralcantara

robert99

khadraouihiba02

appi_priyakarna

Popular Resources

View All

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!

Collaborate

Healthcare User Group

A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..

All are welcome

Japan Group

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Brasil Group

Brazil

Welcome to the group for Brazil users. .All discussions will be in Portuguese.

open to all

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!

Welcome to Qlik Community!

Welcome to Qlik Community

Recent Discussions

Lots of Qlik Talend Data Integration Sessions!

Qlik Community How To's

Do More with Qlik - Delivering Real-Time, Analytics-Ready Data

High Five

Meet Fabian

Popular Resources

Customer Story

Customer Story

Location and Language Groups

Healthcare User Group

Japan Group

Brasil Group

Blogs

Welcome to
Qlik Community!