Discussion Board for collaboration on QlikView Scripting.
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?
Do you mean something like:
LOAD * INLINE [
LOAD * INLINE [
Then you could create a chart with an expression using the concatenated values of Sales_Associate_ID2 :
Hope this helps.
Here is a screenshot a chart I create with a dimension of
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.
Isn't this the same issue we are discussing here for days now?
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.
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.