topic customer ( 80% revenue ) per product in App Development

customer ( 80% revenue ) per product

jakekur — Tue, 09 Aug 2022 05:50:57 GMT

Hi, i am new at qlikview. i have a question about pareto

this expression only works in text box but i would like for straight table chart

Count({<[NamaCust] = {"=Aggr(RangeSum(Above(Sum(SalesAmt), 0, RowNo())), ([NamaCust], (=Sum({<[NamaCust]>} SalesAmt), Desc)))/Sum(TOTAL SalesAmt) <= 0.8"}>} DISTINCT [NamaCust])

please advise. thks

Re: customer ( 80% revenue ) per product

Mark_Little — Tue, 16 Aug 2022 06:34:22 GMT

HI @jakekur

You want to take a look at the accumulation modifier for the expression,

Re: customer ( 80% revenue ) per product

jakekur — Mon, 29 Aug 2022 03:19:15 GMT

Hi Mark, any sample you can provide ? thks