Issue "and clause in set analysis"

[Sagar082]

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.

[Gabriel]

@Sagar082 

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

This will then help community to help

[GaryGiles]

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.

[Sagar082]

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. 

[Sagar082]

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. 

[Sagar082 · Accepted solution]

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.