Reducing the size of a qvw

[Anonymous]

How does "group by" function help reducing the size of a qvw?

Thanks!

[Anonymous]

If your raw data is say at City Level and you aggregate it at Country level exploiting Group By then you have less data and so smaller qvw.

You do need to look at the wider picture though and decide whether or not disposing of the City level data is a good or bad thing to do.

[JonnyPoole · Accepted solution]

Hi ,   A group by in your SQL will usually reduce the number of rows you are loading into QLIK.  Sheer data volume does have an impact on your QVW size but also number of columns as well as the uniqueness of data.

If you do a group by there will typically be less data , potentially a lot of less data , but your data will also be more unique (summarized) and won't compress as much.

So yes by and large it will reduce the QVW but the exact amount will depend. Hope it helps.

[Anonymous]

Great, thanks!

[JonnyPoole]

However, if you are just testing limited data sets, there are a couple options:

Add the following just before your load statement  where 10 is the number of records that you want the load to load

First 10

Load *

from source;

You can alternatively hit the 'debug' button on the left side select 'limited load' to load only a few records. The first option allows you to control the load per table so a bit more detailed.

[Anonymous]

Thanks... what are the cons of using group by? Thanks again!

[JonnyPoole]

I don't really see one except that you won't have drill down access to the underlying details.

[Anonymous]

Thanks!