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: 
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)

View solution in original post

farru_scorpio
Contributor III
Contributor III
Author

Thank you Sunny, perfect. 🙂

b_garside
Partner
Partner

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