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: 
farru_scorpio
Contributor III
Contributor III

Repeating aggr value in straight table against each Branch

Dear Experts,

I need a simple thing to have, let's say I have two dimensions as Branch and Product and expression as  Sales like shown below: I am looking for last column calculation.

(Branch) (Product)  (Sales)     (Aggr Total Branch Sales in each row) << this is required.

AAA             AIR           5000           7000

AAA            HOTEL     1500          7000

AAA            CAR             500          7000

BBB           AIR             3000         3400

BBB          RAIL             400          3400

CCC          HOTEL       1000         1500

CCC          MISC             500         1500

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

Try this

Sum(TOTAL <BRANCH> Sales)

or

Aggr(NODISTINCT Sum(Sales), BRANCH)

View solution in original post

3 Replies
sunny_talwar

Try this

Sum(TOTAL <BRANCH> Sales)

or

Aggr(NODISTINCT Sum(Sales), BRANCH)
farru_scorpio
Contributor III
Contributor III
Author

Thank you Sunny, perfect. 🙂

b_garside
Partner - Specialist
Partner - Specialist

Who knew it would be as simple as adding the NonDistinct clause!