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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
kiranpatil123
Contributor III
Contributor III

Expression help

Hi All , 

quote noNameQuoted %
1xy1010/200
2xy8080/200
3xy6767/200
4xy3333/200
5xy1010/200

 

Need help on the expression . I need the % column to be achieved .
Group by Customer name i need % example - 10 / 200 (Total quoted number) 

Advance Thanks

Labels (2)
1 Reply
dplr-rn
Partner - Master III
Partner - Master III

You need total qualifier.
something like below
Sum(Quoted)/Sum(total<Name> Quoted)

https://community.qlik.com/t5/Qlik-Design-Blog/What-does-the-TOTAL-qualifier-do/ba-p/1472990