Discussion Board for collaboration related to QlikView App Development.
I have 2 tables which are not associated to one another but have the same dimension values.
I would like to display the sum of values for second table with respect to first table dimensions:
* INLINE [
A, B, C
LOAD * INLINE [
X, Y, Z
The result must be, even when selections(B=B1) are made:
But the result when B =B1 is
Pick could be not very handy, when u r going for more number of dimension data. Let us know what data model u have now and what u want to achieve. may be we can help in some other way to fix it...
I have an island table in my application which is being used as the data in the main table is getting reduced due to data reduction.
So whenever I show values in the straight table, I am using a series of if conditions to check whether the dimension in actual table is equal to that of island table and then evaluating the expression.
But if some of the values are greyed out due to certain selections, I am unable to access those dimension in the expression column.
Want to access those greyed out dimension values also in my expression.
Hmmm i see what you mean. That is odd behavior. It seems like it reduces the set to what you have selected when you hit the reload button. Undoubtedly its caused by the data model (since there is no link between the field Z and field A). But whether or not it should be doing that, I do not know.
What might be easier, is just use the fields X and Z in the straight table. Not sure where the field A comes into play, cause it seems like you want to ignore selections. But if you want to incorporate A in there somehow, it may be easier just to add that logic to the table with fields X and Z instead.
Other resolutions may come from doing things in the loadscript and then dashboard, but I do not know what you are doing in your real solution so I can't say for sure. If you wish to attach an example that better resembles what you are doing in your solution, we can maybe take a look at it.
Hope this helps!