topic Re: Issue "and clause in set analysis" in App Development

Issue "and clause in set analysis"

Sagar082 — Fri, 02 Apr 2021 08:42:48 GMT

Hi Everyone,

Greeting for day. I am using the following set analysis, but and clause is not working.

Count({$<[Lifecycle State] = {'Registered'}> + 1 <Link_status = {'$(vMeasure)'}> }Source_Node)

even I tried out;

Count({$<[Lifecycle State] = {'Registered'}, Link_status = {'$(vMeasure)'}> }Source_Node)

But, if I chose any option in variable input button, it dosen't consequently result.

I did check, whether the defined variable capturing the chose option or not. It is capturing.

Regards,

Sagar.

Re: Issue "and clause in set analysis"

Gabriel — Tue, 10 Nov 2020 12:18:04 GMT

@Sagar082

Are you able to explain what you wanted to achieve with the expression above?

This will then help community to help

Re: Issue "and clause in set analysis"

GaryGiles — Tue, 10 Nov 2020 12:28:17 GMT

One way to troubleshoot expressions with variables in set analysis is to go into the edit expression window for the expression and look at the bottom of the window. It will show you the expression with the variable value inserted. Look at this before you make a selection in the variable input and afterwards. Posting a screenshot of that would be helpful if you still can't figure it out.

Re: Issue "and clause in set analysis"

Sagar082 — Wed, 11 Nov 2020 06:06:11 GMT

Hi Gabriel,

Greeting for the day. I would like the get the result like;

if the Life_cycle = Register and Link_status = vMeasure (selected variable) then it should give me count of those observation which satisfies both the condition.

I hope this will help you to understand the issue.

Regards,

Sagar.

Re: Issue "and clause in set analysis"

Sagar082 — Wed, 11 Nov 2020 06:07:56 GMT

Hi GaryGiles,

Greeting for the day. Thank you for reply and suggestion. I always do this exercise before hand. In the above case the variable value is capture correctly, but some how and clause is not functioning.

Regards,

Sagar.

Re: Issue "and clause in set analysis"

Sagar082 — Thu, 12 Nov 2020 06:38:45 GMT

Hi folks,

Greeting for the day. Thank for reading my queries and attempt to reply it, to help me to resolve it.

I found the solution to my queries, which may help someone too;

Count({$<Column name1 = {value1}, column name2 = {$(vMeasure)}>} field)

The above expression will return the count of field if both column 1 and column 2 condition satisfies. But, the twist is that column 2 condition value will be tested on the bases of user selection.

Regards,

Sagar.