topic selection without keys in QlikView

selection without keys

Fri, 25 Nov 2011 14:28:45 GMT

Hello Togehter,

I have a idea to solve a specific problem and dont know if that would ever be realized in Qlikview ?

I want to demonstrate you my problem with the basis of the example sketch.

First I select some values from the two tables above. The values above are selected. So far so good.

The desired behavior is now, that the 2 previously selected tables above to makes the selection

to the lower Table (Green and Red Values) ? Is it possible ?

I am looking for a alternative way without to link the tables with keys.

I am very thankful for any help .

Best Regards,

selection without keys

rwunderlich — Fri, 25 Nov 2011 15:29:32 GMT

This is possible. Two different approaches.

1. If you want to just logically associate the fields without actually selecting in the second table, use the "data island" approach (search the forum if you're not familar with it).

2. If you want to make an actual selection in table two, use an action as discussed in this thread.

http://community.qlik.com/thread/35764?start=0&tstart=0

-Rob

http://robwunderlich.com

Re: selection without keys

Fri, 25 Nov 2011 19:37:23 GMT

Hi Rob,

thanks for these good two advices.

I like the second option that you proposed quite well. But somehow it will not works !

I want to click on a blue highlighted value and want a automatic selection to the SID Table.

Unfortunately, I cant link the (green) fields with a key, because otherwise I risk a circular reference.

Can you please have a look out my example qvw ?

Thank you very much !

Re: selection without keys

rwunderlich — Fri, 25 Nov 2011 22:26:10 GMT

Ok, I think I understand your requirement. There were a few methods referenced in that thread, you need the one that considers the possibles.

='=sum({<SID_KOSTENSTELLEN=P(KST_KOSTENSTELLE)>} 1)'

See attached example.

-Rob

http://robwunderlich.com

Re: selection without keys

Fri, 25 Nov 2011 22:27:56 GMT

Thank you Rob. Thats it