Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
ajaykumar1
Creator III
Creator III

Script failed without any error.

Hi All,

I have the 2 qvd's which contains the date field  namely  Date_end(Extractor level) which contains data from March 2008 to Nov 2013 and the date format type is 03/01/2013.

I need to fetch the data only for last 13 months with the use of Date_end.(which is coming from already existing qvd and using at extractor level)

After fetching that 13 months data with 'where' clause then i have to use that Date_end field as Period in application level.(Report level).

I have used the the where clause at extractor level to fetch only 13 months data.It is showing "script failed and reload old data" without any error.

Sample data attached here.

Thanks

Ajay Kumar

3 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     QVD 1 and QVD2 both as almost same data, why you need duplicate data?

     And even if you want you can use the concatenate instead of join.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
ajaykumar1
Creator III
Creator III
Author

Thanks..I will the try the same....But in my original data i have the different fields also between QVD1  and QVD2.The result of the join , i have to use in some other QVD level.

If am trying to fetch last 13 months data from QVD (at extractor level) am getting the above problem Otherwise script runs successfully.

What might be the possible causes to get the problem like "Script failed and reload old data".(Not showing any error while debugging).

Thanks,

Ajay Kumar

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     Its hard to say the reason for the error without actually looking at your script.

     So if possible share the script.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!