# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for
Did you mean:
Creator III

## Show sum total on all rows

Hi,

I have the following expression with Set analysis which is working well and giving the individual values required:

Sum({\$<Location = {'UKInv'},[Retailer Name] = {'Brand'}>}[Stock In House])

I now need a column next to this which required the the total of the above.

In the below simple example the above return 2,8,2 and i need an expression to give the total= 14 on each line

e.g.

Above SUM    TOTAL SUM
2                           14
8                           14
2                           14

Please can someone assist in making an expression to give me the total from this:

Sum({\$<Location = {'UKInv'},[Retailer Name] = {'Brand'}>}[Stock In House])

Daniel

Labels (3)

• ### Total

2 Solutions

Accepted Solutions
Partner

hi

have you tried

``Sum({\$<Location = {'UKInv'},[Retailer Name] = {'Brand'}>}total [Stock In House])``
Partner

hi this should work

``Sum({\$<Location = {'UKInv'},[Retailer Name] = {'Brand'}>}total<[Item Code],[Size Table]> [Stock In House])``
5 Replies
Partner

hi

have you tried

``Sum({\$<Location = {'UKInv'},[Retailer Name] = {'Brand'}>}total [Stock In House])``
Creator III
Author

Thank you so much for this and your quick response. This has worked perfectly.

Thanks, i knew i had to get a total in there but wasted so much time trying to get the positioning right with no error.

Much Appreciated...Stay safe and Thanks again.

Daniel

Creator III
Author

Hi again,

I wonder if you could help again.

When using the given expression:

Sum({\$<Location = {'UKInv'},[Retailer Name] = {'Brand'}>}total [Stock In House])

i also need to 'filter'/split the total by 2 dimensions

Item Code and Size Table.

This is so that i get the total sum of the stock in house by location and retailer name, But, a total for each change in item code and Size Table.

The expression above works great when i make those 2 filters however there are too many to fix like [Item Code] = {''item name} etc

Is there a way to filter the total in the given expression using those 2 dimensions?

so i get like below;

Item code    Size Table    qty      total

A                          A B                 2          14
A                          AB                 10         14
A                          AB                  2          14
b                           bb                 2           10
b                           bb                 8           10

Thanks Again @lironbaram

Partner

hi this should work

``Sum({\$<Location = {'UKInv'},[Retailer Name] = {'Brand'}>}total<[Item Code],[Size Table]> [Stock In House])``
Creator III
Author

SERIOUSLY!!

As easy as that, the more i think i know the less i do.

You have massively helped me out today @lironbaram ... i cannot thank you enough!

Thanks so much, enjoy the rest of your day.