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
Not applicable

Set Analysis with Math Operations

Hello,

I am having a little bit of trouble with the syntax of Set Analysis. When I write something like this:

sum( {$<NumberTest={"<=$(=sum(TotWeightedCasesCompare))"}>}  PeerAmount)

It will evaluate as expected. When I try something like this:

sum( {$<NumberTest={"<=$(=sum(TotWeightedCasesCompare))/$(=sum(TotCasesCompare))"}>}  PeerAmount)

The expression will no longer evaluate properly. Is performing division in this instance not allowed, or do I just have the syntax wrong?

4 Replies
Highlighted

Re: Set Analysis with Math Operations

Try this ways

=sum( {$<NumberTest={"<=$(=sum(TotWeightedCasesCompare))"}>}  PeerAmount)

/

sum(TotCasesCompare)

Regards,

Anand

Highlighted

Re: Set Analysis with Math Operations

May be this

Sum({$<NumberTest = {"<=$(=Sum(TotWeightedCasesCompare)/Sum(TotCasesCompare))"}>}  PeerAmount)

Highlighted
sasiparupudi1
Honored Contributor III

Re: Set Analysis with Math Operations

sum( {$<NumberTest={'<=$(=sum(TotWeightedCasesCompare)/sum(TotCasesCompare))'}>}  PeerAmount)

Highlighted
Partner
Partner

Re: Set Analysis with Math Operations

sum({<NumberTest={"<=$(=sum(TotWeightedCasesCompare/TotCasesCompare))"}>}PeerAmount)

probably this will work. but still i m unable to understand what is exactly ur requirement is.

thanks