QVD created but not data stored

[#1]

I have an issue with writing data to qvd. I have a query like this:

Temp_Tranform_data: // Main transformation query of fact table.

Load

  contact_id,

    Date(Floor(startDateTime - (60/24/60)),'MM/DD/YYYY') as 'Date', // convert from EST to CST

...

From [lib://My_qvd_path\tblcalldetail.qvd](qvd)

Where [conditions];

Store Temp_Tranform_data into [lib://My_qvd_path\IBcalldetail_hr.qvd](qvd);

Drop Table Temp_Transform_data;

Then when I go to load the data from [lib://My_qvd_path\IBcalldetail_hr.qvd](qvd), there are only the column headers and no data. I've tried using different directories and loading to different files hoping it was a weird glitch  with no luck. Has anyone encountered this issue?

[rittermd]

Probably stupid questions.

1.  Have you opened the original qvd and confirmed that it has data?

2.  Is it possible that your where clause is not working and as a result is not selecting any data?

Can you provide the actual Where Clause that you are using?

[#3]

The source file has data.

The where clause it a qlik emulation of a TSQL query that returns data:

Where contact_id = Master_contact_id

and OutboundSkill = 0

and startDateTime >= Date#('01/01/2016 00:00:00','MM/DD/YYYY hh:mm:ss')

and not WildMatch(skill_name,'*DNU*')

and not WildMatch(skill_name,'*IVR*')

and not WildMatch(skill_name,'*x')

and not WildMatch(skill_name,'*transfer')

and not WildMatch(skill_name,'*test*')

and not WildMatch(skill_name,'8*')

and not WildMatch(skill_name,'*sandbox*')

and not WildMatch(team_name,'Silver*')

and skill_name <> 'Deactivated POC Skill'

and team_name <> 'Admin'

and media_name = 'Phone Call';

[rittermd]

I have encountered situations where the syntax of the where was correct but it did not return any data.  It usually happens with a date/time field. 

If this was my code I would comment out line by line of the where and see if I am getting data and when it stops.  If it doesn't take too long to run.

I can't think of any other reason that you are not getting data in the new qvd.

[#5]

It worked! Thank you so much!

[Anonymous]

Hi,

Try Num(startDateTime) >= Date#('01/01/2016 00:00:00','MM/DD/YYYY hh:mm:ss').

I had to do this for one of my where clauses.

[Anonymous]

No problem glad to help!