topic Re: Set Analysis subset selection issues in App Development

Set Analysis subset selection issues

Krish — Tue, 30 Nov 2021 18:17:33 GMT

I have a set analysis for a text object to calculate sum of all employees starting with 4.

sum({<empid={"4*"}>}sal)

But when a particular emp id like 4000 is selected, that is not showing for 4000 and still showing for all employees with 4.

How to achieve this.

Re: Set Analysis subset selection issues

GaryGiles — Sun, 20 Jun 2021 16:08:20 GMT

You'll want to use an * before the equal sign to create an intersection between the currently available empids and the criteria specified in the set analysis, like this:

sum({<empid*={"4*"}>}sal)

Re: Set Analysis subset selection issues

Anil_Babu_Samineni — Sun, 20 Jun 2021 20:21:23 GMT

I agree with @GaryGiles here, But you can still try multiplying with dummy row alike.

sum({<empid={"4*"}>}sal)*Sum({$} 1)

Re: Set Analysis subset selection issues

Krish — Mon, 21 Jun 2021 19:09:56 GMT

Works perfectly. Thank you!!