Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to sum measure without 1 row in the excel file (Data Source)?

Hi experts,

let say this is the data from my excel file.

ShopProductSales
ADDD300
BDDD400
TOTAL700

For some reason, the TOTAL rows i need to keep in the excel file.

There are 21 shop in the excel

so when i use formula:

SUM(Sales)

The result = 1400.

so how to filter it?

Thank you in advance!

1 Solution

Accepted Solutions
OmarBenSalem

change ur measure as folow:

sum({<Product-={'TOTAL'}>}Sales)

View solution in original post

4 Replies
OmarBenSalem

change ur measure as folow:

sum({<Product-={'TOTAL'}>}Sales)

justinphamvn
Creator II
Creator II

Hi,

Try this:

SUM({<Product -={'TOTAL'}>}Sales)

Hope this helps,

Justin.

Anonymous
Not applicable
Author

Thank you so much!

Anonymous
Not applicable
Author

thank you !