Solved: Grand Total and custom sub total not changed by ap... - Page 2 - Qlik Community

manish_gupta · ‎2025-02-06

Hi Qlik Community,

We have a requirement where we need to design an app in such a way that Grand Total and custom sub total not changed by app filters. For example, I have below hierarchy,

Region----->State----->Store

By Default this is how app would look like

Now when someone select a state from State filter, it would change the data in table including subtotal and grand total, like below

But we have requirement that subtotal for level above the selected filter shouldn't change and show the data as below

I am looking for ideas to implement this solution. Also we have more then 20+ KPIs so any solution which is easy to implement, flexible and extendable would be great for maintenance purpose.

Thank you

Qrishna · ‎2025-02-12

sample data please?

manish_gupta · ‎2025-02-13

Hi @JandreKillianRIC

I have the same levels but multiple KPIs so wanted to check if there is a way to convert your expression into a variable and re use instead of writing the same things again and again.

manish_gupta · ‎2025-02-13

PFA

Grand Total and custom sub total not changed by app filter

Advanced Authoring

Data Model

General Question

SaaS

Script and Expressions

Variables

Visualization