7 Replies Latest reply: Feb 10, 2016 6:25 PM by Hemang Dave

Indirect selection using Set Analysis

Hi

What set analysis expressions could be used, if you were trying to assign values to Sales_Associate_ID1 based on selection made by the user on Sales_Associate_ID2?

one of the functions i could think of is p. So the expression could be

Sales_Associate_ID1 = p(Sales_Associate_ID2)

is there any other way to accomplish the same thing?

Thanks

• Re: Indirect selection using Set Analysis

Can you elaborate more on what you trying to do? May be share a sample if possible?

• Re: Indirect selection using Set Analysis

Hi Hemang,

Do you mean something like:

sales1:

Sales_Associate_ID1,value1

A,1

B,2

];

sales2:

Sales_Associate_ID2,value2

C,3

D,4

A,5

];

Then you could create a chart with an expression using the concatenated values of Sales_Associate_ID2 :

=sum({<Sales_Associate_ID1={\$(=Concat(Sales_Associate_ID2,','))}>} value1)

Hope this helps.

Mark

• Re: Indirect selection using Set Analysis

Here is a screenshot a chart I create with a dimension of

Sales_Associate_ID1

expression:

=sum({<Sales_Associate_ID1={\$(=Concat(Sales_Associate_ID2,','))}>} value1)

Thanks

Mark

http://techstuffybooks.com

• Re: Indirect selection using Set Analysis

Hi Mark

I am not looking to create a chart for this problem but just trying to get correct values in a table based on these selections.

Thanks

• Re: Indirect selection using Set Analysis

Isn't this the same issue we are discussing here for days now?

Indirect Selection (P function etc.)

If you think Vlad and myself are on the wrong track, please tell so. I am still waiting for some requested information, like what you see returned from your expression and what you expect to get instead and if you can prove that there are potentially matching values for the combination of field modifiers used.

IMHO, posting duplicate threads makes it very hard to follow a discussion, so should be avoided.

• Re: Indirect selection using Set Analysis

Point well taken. Apologies for the same discussion in a separate thread. My intent was to start a fresh thread and try to get a fresh perspective with a simplified description of the problem. Wasn't sure if i was addressing the same audience.

Thanks

• Re: Indirect selection using Set Analysis

Thanks Sunny & Mark

Following picture will make it clear.

Here, the user is selecting rating_contact_id 917 on the front end. Now, using the set analysis (not on the UI) i need to make selection that says history_rating_contact_id = '917' based on user's selection of rating_contact_id 917.

I've tried using p function for this, i.e using the expression;

history_rating_contact_id = p(rating_contact_id)

but it won't work. So need to explore if there is any other function besides p function that could be used to make this indirect selection.