Skip to main content

# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save \$300 before February 6: REGISTER NOW!
cancel
Showing results for
Search instead for
Did you mean:
Creator

## Sum in pivot table, percental ratio and rank of the customers

Hello, I have problems in my Pivot table. Expresion '1' and '4'  are OK, it works. Expresion '1' and '4' are set analyse (Sum ({< [Division] = {'5' , '7'}, [Account] = {"602*", "601*", "604*"}, \$(vSetMaxFinanceYear)>} [Incomes]) ) But I have problems in other expresions. I dont know :

- how to sum incomes in pivot table and then

- count rank of the customers.

Here is my resulted table, expression '1' '4' is working, other expressions not working.

 Dim 1 Dim 2 Expr 1 Expr 2 Expr 3 Expr 4 Expr 5 Expr 6 Cust. Cust ID Incomes Jan-Mai 2016 % ratio Rank 2016 Incomes Jan-Mai 2015 % ratio Rank Windmol WIND02 423846,19 21,84% 1 523846,19 24,53% 1 Ligumol LIGU00 237746,80 12,25% 3 287746,80 13,48% 2 Brucmol BRUC00 274481,94 14,14% 2 275659,12 12,91% 3 Bonamol BONA00 168560,00 8,68% 4 172459,69 8,08% 5 Manrol MANR03 157260,69 8,10% 5 102360,12 4,79% 9 Neusir NEUS01 131550,80 6,78% 6 91058,00 4,26% 11 Stilmol STIL00 91755,60 4,73% 11 140250,23 6,57% 7 Menzos MENZ00 117615,86 6,06% 8 174125,61 8,15% 4 Amcmol AMCM00 110858,16 5,71% 9 100250,71 4,69% 10 Lemomol LEMO00 101077,49 5,21% 10 112365,12 5,26% 8 Etcimol ETCI00 126234,04 6,50% 7 155210,13 7,27% 6 1940987,57 2135331,72
1 Reply
MVP

For ratio expression, try this:

Sum({<[Division] = {'5' , '7'}, [Account] = {"602*", "601*", "604*"}, \$(vSetMaxFinanceYear)>} [Incomes])

/

Sum(TOTAL {<[Division] = {'5' , '7'}, [Account] = {"602*", "601*", "604*"}, \$(vSetMaxFinanceYear)>} [Incomes])

For Rank expression, try this:

Rank(TOTAL Sum({<[Division] = {'5' , '7'}, [Account] = {"602*", "601*", "604*"}, \$(vSetMaxFinanceYear)>} [Incomes]), 1, 1)

Community Browser