Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

7 Replies
sunny_talwar

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

markodonovan
Specialist
Specialist

Hi Hemang,

Do you mean something like:

sales1:

LOAD * INLINE [

Sales_Associate_ID1,value1

A,1

B,2

];

sales2:

LOAD * INLINE [

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

markodonovan
Specialist
Specialist

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)

Capture.PNG

Thanks

Mark

http://techstuffybooks.com

Not applicable
Author

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.

Bets_Pic.PNG

Not applicable
Author

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

swuehl
MVP
MVP

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.

Not applicable
Author

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