I have a tricky scenario where i have a straight table and a set of charts. In the charts i want to show the data as per the filters, but in the straight table i want to show even the non-associated data.
For. e.g. I have a flag which selects data from data source A or B, both data sources are concatenated facts separated by a data source flag. They also have separate volume columns.
Now, when i select the Data Source A, the charts works fine, but the straight table is expected to show both the volume columns ir-respective of the flag which is selected. So, it has to show the data which is not associated. Also, the other filters should work with the un-associated data of Source B.
Let me know how this could be achieved in QlikView (preferably without using alternate states).