topic Re: null coming in script in QlikView

null coming in script

Anonymous — Thu, 28 Jan 2016 12:55:04 GMT

Hi All,

I had written script and null value is coming for variable. But that variable is having some value.

Inserts:

LOAD *FROM

$(Vqvdpath)fact_site_visit.QVD (qvd);

MaxDates:

LOAD Max(site_visit_updated_datetime) as MaxDate

Resident Inserts;

LET vMaxDate = Peek('MaxDate',0,'MaxDates');

DROP TABLE MaxDates;

In above for vMaxDate null value is coming. But it is having max value. Where it is wrong. I think my script is correct. Can anyone tell me where it is going please guide me

Re: null coming in script

NareshGuntur — Thu, 28 Jan 2016 13:00:18 GMT

Hope you have checked the count of the table MaxDates before dropping it.

Re: null coming in script

sasikanth — Thu, 28 Jan 2016 13:01:27 GMT

HI,

are you able to load the data ? if not check '\' there in that variable or not

LOAD *FROM

$(Vqvdpath)fact_site_visit.QVD (qvd);

LOAD *FROM

$(Vqvdpath)\fact_site_visit.QVD (qvd);

Check site_visit_updated_datetime format

Re: null coming in script

Anonymous — Thu, 28 Jan 2016 13:06:19 GMT

Thanks for your reply. I am able to load the data. Only when I do max there it is creating problem.

Date format is dd/mm/yyy hh:min:ss

Re: null coming in script

sasikanth — Thu, 28 Jan 2016 13:08:43 GMT

can you share your QVD ? with limited load

Re: null coming in script

markodonovan — Thu, 28 Jan 2016 13:10:58 GMT

Hi Kumar,

Could you remove the DROP TABLE MaxDates; and check the table viewer to check the table is being created correctly.

If you could upload an app it would be helpful.

If the QVD is loading OK there shouldn't be a problem.

Thanks

Mark

Re: null coming in script

Anonymous — Thu, 28 Jan 2016 13:12:52 GMT

Syntax looks okay, if you can share some sample data or app, would be great?

You may also try like this?

Inserts:

LOAD *FROM

$(Vqvdpath)fact_site_visit.QVD (qvd);

MaxDates:

LOAD Max(site_visit_updated_datetime) as MaxDate

Resident Inserts

where site_visit_updated_datetime<>' ';

LET vMaxDate = Peek('MaxDate',0,'MaxDates');

DROP TABLE MaxDates;

Re: null coming in script

Anonymous — Thu, 28 Jan 2016 13:16:10 GMT

my QVD is having 20 gb of data.

Re: null coming in script

sasikanth — Thu, 28 Jan 2016 13:19:42 GMT

conditional load can help

Load * from qvd where condition;

Re: null coming in script

Thu, 28 Jan 2016 13:28:05 GMT

To debug the issue enable log file and add trace function to your variable values.

Your script looks correct. I would say, do drop the maxdates tables and check the MaxDate have the value or not.

What is your date format in "site_visit_updated_datetime" ?

Re: null coming in script

HirisH_V7 — Thu, 28 Jan 2016 13:59:14 GMT

Hi,

Check with this,

Temp:
LOAD * INLINE [
    ShipDate
    09/01/2014 08:19:20
    10/01/2014 08:19:22
    11/02/2014 08:12:20
];


Data:
LOAD
  TimeStamp(Min(TimeStamp#(ShipDate,'DD/MM/YYYY h:mm:ss')),'DD/MM/YYYY h:mm:ss')as MinDate,
  TimeStamp(Max(TimeStamp#(ShipDate,'DD/MM/YYYY h:mm:ss')),'DD/MM/YYYY h:mm:ss')as MaxDate
Resident Temp;
Drop Table Temp;

LET vMinDate = floor(peek('MinDate'));
LET vMaxDate = floor(peek('MaxDate'));

Output:

Check this too in your app,

SET TimeFormat='h:mm:ss TT';
SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YYYY h:mm:ss[.fff] TT';

AND MODIFY Accordingly

And Modify Accordingly,

Hope this helps,

PFA,

Hirish

Re: null coming in script

markodonovan — Thu, 28 Jan 2016 14:43:30 GMT

Hi Kumar,

You can also hover over the field in the tableviewer to see if qlikview has recognized the field as a $date\$timestamp with the tags it gives the fields.

Thanks

Mark

http://techstuffybooks.com