Discussion Board for collaboration related to QlikView App Development.
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
Sum(TOTAL <BRANCH> Sales)
Aggr(NODISTINCT Sum(Sales), BRANCH)
View solution in original post
Thank you Sunny, perfect. 🙂
Who knew it would be as simple as adding the NonDistinct clause!