Apps counted twice in capacity consumption

[Stas_vd_Braber]

Hi all,

The new capacity model of Qlik counts the data for analysis in GB as consumption. This consists of two elements in the management console: 

1. App reload

2. Datafile

Now we encounter some issues with our 'regular' way of working, where the same app is counted twice in capacity consumption. Once with the shared space app and once with the managed space app. Our view of a shared space was that the collaborative editing part was one of its strong points. Therefore, we had the 'source' app in a shared space and the 'published' app in a managed space. With the capacity consumption now counting twice, we are somewhat forced to move the app to a personal space, reload  the app with necessary changes, and then move the app back to the shared space. Reloads in a personal space are not counted in capacity consumption. Furthermore, an app that has been reloaded 2 months ago is still counted as capacity consumption in current month!! In my perspective, a monthly check on consumption should only check that particular month. This implies that even if the shared space app has not been reloaded for months, it still counts twice in capacity consumption. The only fix I found was deleting and re-uploading the app. I cannot imagine that this is the desired way of working! What are your views and best practices on working with this new capacity model?

[marksouzacosta]

Hi @Stas_vd_Braber,

This is very odd. I believe your expectations are correct. The app should not count in the current month consumption if it was not reloaded in the current month.

Quick question: what is the data source of your dashboards?

Regards,

Mark Costa

[Stas_vd_Braber]

Hi @marksouzacosta,

The data source is mostly Snowflake.

[marksouzacosta]

Great. I think you know this already, but just in case, you could store the required Snowflake tables as QVD/Parquet files and use those in your dashboards. Only the QVD/Parquet Datafile load and storage size will count against your Capacity Subscription. Loading the Qlik Cloud stored files on Analytic Apps will not count.

One interesting thing to quick check the data consumed, use the URL structure below, replacing the values in the {} brackets:

https://{tenant_url}/api/v1/apps/{app_id}/reloads/metadata

Look for the loadExternalBytes field:

Regards,

Mark Costa

[Stas_vd_Braber]

Yes, the app in question now loads data from snowflake and stores it as QVD file on the Qlik Cloud. The main issue here is that the ‘shared’ version of the extract app, which has last been reloaded two months ago, is also counted in the capacity consumption. Therefore, the ‘same’ app is counted twice. I cannot imagine that to avoid duplicate counting in capacity consumption one has to move the shared space version to personal in order to perform a reload. 

Thanks for the tip on loadExternalBytes, this helps for customers currently on subscription based license. 

[PrashantSangle]

little bit confused about when you say " Therefore, the ‘same’ app is counted twice". I never seen this. Do you mean to say 2 copy of same app?

Agree on, regarding if app reloaded in last month and not loaded in this month & still it is counting against capacity of this month. "A monthly check on consumption should only check that particular month."

In Such type scenario, we have to delete that app & reupload without data or If we are using that app for extraction phase only then convert that extractor app into Script file. Script file also doesn't count against Capacity Consumption.

Regards,

Prashant Sangle

[marksouzacosta]

Hi @PrashantSangle,

I was curious about you saying that "Script file also doesn't count against Capacity Consumption".
I checked one of our customers Consumption Report and Script files (stored in Shared Spaces) does count against Capacity Consumption. The top two are Script Apps:

Maybe you are doing it in a way that does not count against Capacity. Can you please clarify?

Thank you,

Mark Costa

[Stas_vd_Braber]

Hi @PrashantSangle

The shared space app is counted in capacity consumption and the managed space published version of the same app is counted in capacity consumption. 

[PrashantSangle]

where did you get App id for script files? I am getting Script id.

[PrashantSangle]

ohh.. So in this case definitely, it will consider 2 apps  because here you have 2 different app id. Even if you create copy of same app in same space then also it will consider as 3rd app. 

regards,

Prashant Sangle