Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

gauravgg
New Contributor III

Error while executing the following expression ?

hi

sum({$<verification_status = {"VC"}>} (sum(so_net_amount)/sum(total so_net_amount)))

Tags (1)
4 Replies
sureshqv
Esteemed Contributor III

Re: Error while executing the following expression ?

try

sum({$<verification_status = {"VC"}>}

sum(so_net_amount)  /

sum(total so_net_amount)))

gauravgg
New Contributor III

Re: Error while executing the following expression ?

MVP
MVP

Re: Error while executing the following expression ?

May be this:

Sum({$<verification_status = {"VC"}>} so_net_amount)/Sum({$<verification_status = {"VC"}>} TOTAL so_net_amount)

or this:

Sum({$<verification_status = {"VC"}>} so_net_amount)/Sum(so_net_amount)

gauravgg
New Contributor III

Re: Error while executing the following expression ?

thanks sunny

this worked

Sum({$<verification_status = {"VC"}>} so_net_amount)/Sum({$<verification_status = {"VC"}>} TOTALso_net_amount)