Not able to covert Qlikview app into Qliksense

[shraddha_23]

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.

[shraddha_g]

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

Try any file lesser than 500 MB

[petter]

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]

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]

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

[petter]

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]

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