Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
kiranpatil123
New 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
Highlighted
Partner
Partner

Re: Expression help

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