Reducing offset and length for Qlik sense columns

[deep2021]

Hi All,

My application size has increased drastically.

When I checked XML data for the table I found that the offset values for the columns has increased.

Can you please suggest how to reduce the table size in the above scenario. I need all the columns.

Thanks

[AustinSpivey]

I believe the offsets are just telling you the index at which those symbols start being represented in the symbol table. The culprit appears to me to be the [path] field, which has 6.6 million symbols at a Bitwidth of 23. If you multiply that 6669231 by 23, you get 153392313 which, when added to the other elements here, would likely get you to that length of 179273219.

What do those [path] values look like? Are they all really long? Do you have a few outliers that are particularly large? You could consult this article from Henric Cronstrom that may help to understand how to get an efficient table underneath the hood.

[deep2021]

Hi,

Thanks for the response. Even after commenting path field there is not much impact on app size.

Can you please suggest what can be done?

Thanks

[AustinSpivey]

What version of Qlik Sense are you using?

[deep2021]

Hi,

We are using the below version,

I suspect, increased cardinality as compared with previous versions is the main reason why the application size has increased.

Please find the below example-

New version-

I also found that some of the columns are not in desired format.

Can you please correct me if I am wrong.

Also, can you please also suggest the other parameters that I need to check for the further analysis?

Thanks