Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Tags (1)
7 Replies
sunny_talwar
Not applicable

Re: Indirect selection using Set Analysis

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

markodonovan
Not applicable

Re: Indirect selection using Set Analysis

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
Not applicable

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)

Capture.PNG

Thanks

Mark

http://techstuffybooks.com

Not applicable

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.

Bets_Pic.PNG

Not applicable

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

swuehl
Not applicable

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.

Not applicable

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