Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 Sagar082
		
			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.
 Sagar082
		
			Sagar082
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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.
 Gabriel
		
			Gabriel
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Are you able to explain what you wanted to achieve with the expression above?
This will then help community to help
 GaryGiles
		
			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
		
			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
		
			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
		
			Sagar082
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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.
