Qlik Community

Ask a Question

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 
Search instead for 
Did you mean: 
davyqliks
Creator III
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])

Thank you in advance.

Daniel

Labels (3)
2 Solutions

Accepted Solutions
lironbaram
Partner
Partner

hi

 have you tried 

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

View solution in original post

lironbaram
Partner
Partner

 hi this should work 

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

View solution in original post

5 Replies
lironbaram
Partner
Partner

hi

 have you tried 

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

View solution in original post

davyqliks
Creator III
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

davyqliks
Creator III
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 

lironbaram
Partner
Partner

 hi this should work 

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

View solution in original post

davyqliks
Creator III
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.