Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

guitartrova
Contributor III

Empty data when loading data Qlik Sense

Hello everyone,

I have a challenge that has me somewhat confused, I try to show in a graph the sum of some data, what happens is that when I load the whole month, from day 12 onwards my data goes to zero, and the fields I converted them to empty, now if I do the extraction of data from 12 onwards if you show me the data correctly.

I hope you have understood me I am enclosing the screens to illustrate better.


DATOS1.png

DATOS2.pngDATOS3.png

DATOS4.png

DATOS5.png

DATOS6.png

Tags (1)
6 Replies
Luminary
Luminary

Re: Empty data when loading data Qlik Sense

Hello Mario,

what is the data source here? Excel file or csv by any chance? Any where conditions, joins or if statements in load script which could cause this?

Juraj

Highlighted
guitartrova
Contributor III

Re: Empty data when loading data Qlik Sense

Current script

[COMPRA_DIARIA]:

LOAD EMPRESA,

NOINS, TIPOMEDICION, PUNTOSIMEC, MARCA_MED, DATETIME, ID_DATE,KWHD,KWHR, PROTOCOLO,

CATEGORIA,

  Year([DATETIME]) as Year,

  Month(DATETIME) as Month,

  Day(DATETIME) as Day,

  Date(monthstart(DATETIME), 'MM-YYYY') as MonthYear;

SELECT m.empresa,p.NOINS,m.tipomedicion,m.puntosimec,m.marca_med, p.DATETIME,p.ID_DATE,

CASE WHEN p."'KWHR'" = 0 THEN p."'KWHD'" ELSE p."'KWHR'"  END AS  KWHR, 

CASE WHEN p.NOINS IN('46357228','35278430','35417324','35307726','46357733','35278127',

'35278329','35307625') AND p."'KWHD'" > 0 THEN 0 ELSE p."'KWHD'" END AS KWHD,

m.protocolo,m.categoria

from VTA_DIARIA p, QLK_MEDICIONES_COMPRA_ENERGIA m

where p.DATETIME >= to_date('20180801','YYYYMMDD')

AND p.noins = m.noins;

guitartrova
Contributor III

Re: Empty data when loading data Qlik Sense

just did the data extraction in a version of older qlik (Version September 2017) and it worked for me.


I think it's a problem with the version of qlik I have installed (June 2018)


Luminary
Luminary

Re: Empty data when loading data Qlik Sense

I haven't played with June 2018 much yet. But looking at your script it looks OK to me, so as you suggest, there might be some issue with this version of Sense.

dwforest
Valued Contributor

Re: Empty data when loading data Qlik Sense

Is DATETIME really a date or just a string in YYYYMMDD?  Could it be YYYYDDMM? This would explain no days over 12,,,,

is your DateFormatString set to "YYYYMMDD"?

guitartrova
Contributor III

Re: Empty data when loading data Qlik Sense

The format is YYYYMMDD.

But it is not a problem of the script but of the version, I already load it in a previous version and it works but I need to make it function in the current version.