topic Re: Indirect selection using Set Analysis in QlikView

Indirect selection using Set Analysis

Wed, 10 Feb 2016 20:36:07 GMT

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

sunny_talwar — Wed, 10 Feb 2016 21:10:22 GMT

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

Re: Indirect selection using Set Analysis

markodonovan — Wed, 10 Feb 2016 21:16:18 GMT

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

Re: Indirect selection using Set Analysis

markodonovan — Wed, 10 Feb 2016 21:19:46 GMT

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

Wed, 10 Feb 2016 21:25:25 GMT

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.

Re: Indirect selection using Set Analysis

Wed, 10 Feb 2016 21:28:02 GMT

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

swuehl — Wed, 10 Feb 2016 23:13:38 GMT

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

Wed, 10 Feb 2016 23:25:31 GMT

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