topic Re: QVW size limit in QlikView

QVW size limit

sonysree88 — Wed, 25 Nov 2020 16:16:04 GMT

Is there any size limit for QVW file ?

Whats the difference b/w QVW and QVD ,QMC,QVPR,QVS?

Re: QVW size limit

Clever_Anjos — Mon, 25 Jul 2016 16:21:22 GMT

QVW is limited by your free memory to load that qvw.

Other definitions you can find into your documenation into help.qlik.com

Re: QVW size limit

maxgro — Mon, 25 Jul 2016 16:25:52 GMT

QMC Qlikview Management Console (manage the server)

web based application (you just need a browser) used to manage the Qlik server environement (server and publisher)

QVPR qlikview repository (server)

Qlikview publisher repository; is where the QMS (Qlikview Management Service) keeps its settings (document, user, license, etc...)

By default, this is in a folder containing XML files; it can be moved to a Sql Server database

QVS usually an include file for qlik script (sub, variables)

More detail:

if you have a file with the .qvs suffix, this is usually an include file of variables and subroutines use in the load script of a .qvw file (using the include or must_include statement)

If you asked for QVS, one of the service of the Qlik server env (QMS QVS DSC QDS QVWS):

QlikView Server (QVS): The QlikView Server service is the core engine of QlikView when deployed on a server. It loads the QVW documents into memory, performs the necessary calculations to present the correct results, and handles user and document memory allocation.

QVD, QVW and QVX

Re: QVW size limit

sonysree88 — Mon, 25 Jul 2016 16:27:52 GMT

Can you please elaborate

Re: QVW size limit

Tue, 26 Jul 2016 06:34:13 GMT

1.Regarding Size limit for QVW - have a look into this Doc RAM Calculation QlikView App. It was explained Clearly.

2. Whats the difference b/w QVW and QVD ,QMC,QVPR,QVS? as maxgro said clearly and check the thread which he was provided at the end of his statement.

Thanks

Re: QVW size limit

Colin-Albert — Tue, 26 Jul 2016 06:54:12 GMT

There is a limit on the number of distinct values in each field.A QlikView app cannot have more than 2,147,483,648 distinct values in any one field. Apart from this you must have sufficient RAM to load the application.

https://help.qlik.com/en-US/qlikview/12.0/Content/limitations.htm

Re: QVW size limit

sonysree88 — Wed, 19 Oct 2016 17:40:49 GMT

Can you any one let me know QVW size approxmetly .

Re: QVW size limit

rupamjyotidas — Wed, 19 Oct 2016 17:52:58 GMT

QVW size would depend on the data present. Please read the documents present in the community as shared by the community above.

Re: QVW size limit

Colin-Albert — Wed, 19 Oct 2016 19:33:28 GMT

The QVW size depends on the data contained in the app and is related more to the uniqueness of the data rather than simply the number of rows.

This post shows how the uniqueness of your data can impact on the QVW size The Importance Of Being Distinct

Re: QVW size limit

Anil_Babu_Samineni — Thu, 20 Oct 2016 02:41:01 GMT

Qvw file size is unlimited if you have good space memory and ram is perfect and then you can store what ever size you want.

As colin size said might be there has limits for distinct values which has not more than that value.

Colin, does this value is a single value for each field?

Left of all good url which max shared. Read there

Hope this helpful

Re: QVW size limit

paulodantas — Mon, 27 Aug 2018 13:47:26 GMT

Hi sonygot,

did you get the correct answer?

If yes, choose the correct answer to close the thread.

Best regards.