topic Re: MISSING DATA in QlikView

MISSING DATA

master_student — Mon, 05 Sep 2016 08:25:09 GMT

Hello everyone,

The data of yesterday is missing from one of my dashbords. How can I reload the missing data?

Thanks for your help.

here's my script :

LET vDate1 = date(Today(), 'YYYY-MM-DD');

LET vDate2 = date(Today()-30, 'YYYY-MM-DD');

LET vDate3 = date(Today()-1, 'YYYY-MM-DD');

noconcatenate

USAGE1:

SELECT

'$(vDate3)' as Date,

...

sum(trunc(RC.net_call_charge_amount/1000,3)) AS TOTAL_RECHARGE

FROM

where RC.call_end_date >= '$(vDate2)'

and RC.call_end_date < '$(vDate1)'

concatenate (USAGE1)

SELECT

'$(vDate3)' as Date,

...

FROM

where RC.call_end_date >= '$(vDate2)'

and RC.call_end_date < '$(vDate1)'

noCONCATENATE

usage:

load date(date,'DD/MM/YYYY') as date,

FROM

[\usage - Copy.QVD](qvd)

WHERE Date(date,'DD/MM/YYYY') < Today()-1

;

Concatenate(usage)

load * resident USAGE1 ;

store usage into [\usage - Copy.qvd] (qvd);

drop table usage;

drop table USAGE1;

Re: MISSING DATA

Anonymous — Mon, 05 Sep 2016 08:34:11 GMT

Hi Wiem,

How do you load your data?

Regards!

Re: MISSING DATA

Anonymous — Mon, 05 Sep 2016 08:35:42 GMT

Make the connection with the data source and reload it

Re: MISSING DATA

master_student — Mon, 05 Sep 2016 08:46:07 GMT

I didn't create the qvw that's why I am asking, In fact after having a look on the application, it uses qvd's load * from QVD and the reload of these qvds (sql queries )are done in another qvw

Re: MISSING DATA

Anonymous — Mon, 05 Sep 2016 09:55:36 GMT

Hi Wiem,

This qvd have data from yesterday or only for today?

Regards!!

Re: MISSING DATA

master_student — Mon, 05 Sep 2016 10:04:49 GMT

the reload job brings yesterday data, the data of 03-09-2016 are not available, the qvd contains data expect 03-09-2016

Re: MISSING DATA

Anonymous — Mon, 05 Sep 2016 10:11:49 GMT

Hi Weim,

If the reload jon brings yesterday data (04/09/2016), and your qvd contains 03/09/2016, you will reload no data. I think that your job must birngs the day before the max data stored on qvd.

Regards!

Re: MISSING DATA

master_student — Mon, 05 Sep 2016 10:13:45 GMT

the data of 03/09/2016 is missing from my qvd.

Thanks

Re: MISSING DATA

Anonymous — Mon, 05 Sep 2016 10:21:40 GMT

You're wellcome!!