topic Problem, is this possible? in QlikView

Problem, is this possible?

Fri, 10 Dec 2010 19:34:28 GMT

My problem is that table B is drilling when ik click dimension (group) in table A, i only want table A to drill when ik click table A, and table B when i click dimension in table B.

is it also possible to have the textbox display the corresponding table??

Problem, is this possible?

Fri, 10 Dec 2010 19:41:48 GMT

I think you would need two separate data sets for that to work. When you make a selection in either table, it is making the selection on your entire data set. Since both tables use the same fields and data, that selection affects both. To keep them separate, you would need two sets of data: Set A and Set B. Then when you make a selection on table A, it only affects Set A. Set B remains with no selections.

EDIT: Since you were just using Inline loads, I implemented the split dataset and posted an example.

Problem, is this possible?

Fri, 10 Dec 2010 22:16:18 GMT

Thanx i allready tried that solution, but was hoping for something easier, because of same facts in all my sheets.

will split my fact tables!

thnx again