Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
jakekur
Contributor
Contributor

customer ( 80% revenue ) per product

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 

 

 

 

Labels (2)
2 Replies
Mark_Little
Luminary
Luminary

HI @jakekur 

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

 

jakekur
Contributor
Contributor
Author

Hi Mark, any sample you can provide ? thks