4 Replies Latest reply: Jun 26, 2018 2:49 PM by sahiba kaur kohli

# Calculate Subtotal and Grand total

hi Team,

I have a list of States in counties X and Y and their respective sales:

Country     State          Sales 2018

X                 A                    100

X                 B                    200

X                 C                    250

X                 D                    50

Y                 E                    400

Y                 F                    150

Now, in qlik sense if I select any State: for example A. Then the output table should show the sum of States as well as the sum of nation. The output should be:

State             Sales 2018

A                     100

All States         600

All Country      1150

• ###### Re: Calculate Subtotal and Grand total

In a KPI object? You can try this

1) State A -> Sum(Sales)

2) All States -> Sum({<State, Country = p(Country)>} Sales)

2) All Country -> Sum({<State, Country>} Sales)

• ###### Re: Calculate Subtotal and Grand total

Hi,

- for all states of same same country as selection :

set analysis like :   sum( {<State = P({\$})            >} sales)

you'll have states matching with state of your selection

- for all countries :

 sum( {1} sales)

regards

• ###### Re: Calculate Subtotal and Grand total
 sum( {} sales)

correction

• ###### Re: Calculate Subtotal and Grand total

Thank you Sunny and Olivier for the answers. It really helped