Empty data when loading data Qlik Sense

[MarioCenteno]

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.

[juraj_misina]

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

[MarioCenteno]

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;

[MarioCenteno]

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)

[juraj_misina]

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]

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"?

[MarioCenteno]

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.