topic Re: Straight Table - Issue with un associated tables in QlikView

Straight Table - Issue with un associated tables

Fri, 19 Sep 2014 16:49:08 GMT

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

    A1, B1,11

    A2, B2,21
A3, B3,31

];

LOAD * INLINE [

    X, Y, Z

    A1, B1,10

    A2, B2,20

    A3, B3,30

];

The result must be, even when selections(B=B1) are made:

A	=Sum(Z)
	-
A1	10
A2	20
A3	30

But the result when B =B1 is

A	=Sum(Z)
	-
A1	10
A2
A3

Re: Straight Table - Issue with un associated tables

jerem1234 — Fri, 19 Sep 2014 17:02:48 GMT

Try this:

pick(match(only({1}A), 'A1', 'A2', 'A3'), Sum({1<X={'A1'}>}Z), Sum({1<X={'A2'}>}Z), Sum({1<X={'A3'}>}Z))

Hope this helps!

Re: Straight Table - Issue with un associated tables

Fri, 19 Sep 2014 17:06:43 GMT

Hi Kurpat,

Unfortunately that doesn't work it still give me the undesired result, which I was talking about.

Please post me the app if it worked for you.

Re: Re: Straight Table - Issue with un associated tables

jerem1234 — Fri, 19 Sep 2014 17:09:17 GMT

Here it is. Please find attached.

Hope this helps!

Re: Re: Straight Table - Issue with un associated tables

Fri, 19 Sep 2014 20:25:33 GMT

It doesn't seem to work after reload

Re: Straight Table - Issue with un associated tables

sundarakumar — Fri, 19 Sep 2014 20:44:03 GMT

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...

-Sundar

Re: Re: Straight Table - Issue with un associated tables

Fri, 19 Sep 2014 21:09:02 GMT

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.

Re: Straight Table - Issue with un associated tables

Mon, 22 Sep 2014 09:19:55 GMT

This is against the rules of qlikview association. May be this doesn't work

Re: Straight Table - Issue with un associated tables

jerem1234 — Mon, 22 Sep 2014 14:30:49 GMT

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!