topic Set Analysis with Math Operations in QlikView

Set Analysis with Math Operations

Fri, 18 Aug 2017 17:07:37 GMT

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?

its_anandrjs — Fri, 18 Aug 2017 17:13:52 GMT

Try this ways

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

sum(TotCasesCompare)

Regards,

Anand

sunny_talwar — Fri, 18 Aug 2017 17:18:06 GMT

May be this

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

sasiparupudi1 — Sun, 20 Aug 2017 20:02:21 GMT

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

mayuresh_d — Mon, 21 Aug 2017 11:33:38 GMT

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

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

thanks