Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
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
its_anandrjs

Try this ways

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

/

sum(TotCasesCompare)

Regards,

Anand

sunny_talwar

May be this

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

sasiparupudi1
Master III
Master III

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

mayuresh_d
Partner - Creator
Partner - Creator

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

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

thanks