Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

shraddha_23
Contributor

Not able to covert Qlikview app into Qliksense

Hi All,

what is maximum size of Qlikview file we can convert into qliksense because i am getting error while converting Qlikview file into Qliksense

(size of qlikview file is as:617 MB)

For reference find attached screenshot.

6 Replies
shraddha_g
Honored Contributor III

Re: Not able to covert Qlikview app into Qliksense

It is mentioned in error that It is larger than 500MB.

Try any file lesser than 500 MB

MVP
MVP

Re: Not able to covert Qlikview app into Qliksense

Have you tried removing all the data from the QlikView application and then saving it? You don't need the data when you are converting - you can just run the load script (reload) after the conversion has finished.

shraddha_23
Contributor

Re: Not able to covert Qlikview app into Qliksense

Hi,

Our Qlikview file size is 617MB ,We can't reduce the size of Qlikview file,is there any way to convert Qlikview file into Qliksense which is larger than 500 MB?

shraddha_g
Honored Contributor III

Re: Not able to covert Qlikview app into Qliksense

if you load qlikview file without data then space will reduce automatically

MVP
MVP

Re: Not able to covert Qlikview app into Qliksense

If you haven't done FILE / REDUCE DATA / REMOVE ALL in the menu of QlikView Desktop you will have the full data set loaded. If you do it you will get rid of all the data and the app should become much smaller. You can't possibly have an empty Qlik application of 617MB.

Try it and see for yourself.

devarasu07
Honored Contributor II

Re: Not able to covert Qlikview app into Qliksense

Hi,

Try to reduce your fact table data by using below script (this code will limit to load latest 3 months data only).

let hDate = date(today()+(day(today())-1));

let dDate = date(MonthStart(today(),-2));

Fact:

load *

FROM $(vQVDPath)\Sales.QVD (qvd) where date(Date)>=date('$(dDate)') and date(Date)<=date('$(hDate)');

PS: remember to update Date field based on your fact field at where clause


still if the file size>500 then try to apply (it will limit to load only latest 3 weeks data)

let hDate = date(today()+(day(today())-1));

let dDate = date(WeekStart(today(),-2));

Thanks,
Deva

Community Browser