Discussion Board for collaboration related to QlikView App Development.
I have two tables, A and B, that have share a few columns, and have a few different ones.
I don't want selections made in Table A to affect Table B and vice versa. These tables are on the same sheet. Is it possible to do this?
Unfortunately what you're trying to achieve goes against Qlikviews core pricipal of association...but as with most things there are a couple of possible work arounds which may help:
1. Detach one of the charts - it will no longer be effected by selections elsewhere in the document.
2. Use Set Analysis to ignore / include certain selections made on dimensions.
3. Place the charts on seperate tabs and use an 'OnSheetActivate' action to clear selections when the new sheet is selected and vice versa.
None of those may solve the problem perfectly but they should help you get there - you may have to compromise in the end.
Hope that helps.
Matt - Visual Analytics Ltd
View solution in original post
I think one way of accomplishing this is by "aliasing" the similar fields by using "AS" in the load script:
LOAD CustomerId AS ChildCustomerId,
Unfortunately, the fields are quite large and this would greatly increase the size of my file, so I'd like to avoid it if possible.
I wouls suggest to use qualify function
I'll have to test a little more, but it looks like detaching is what I was after. Thanks!
In case any one else has this problem, what I ended up doing was checking the "read only box" on the properties --> General tab. It seemed to do the trick.