Using Expressions from Another Table?

microwin88x — Fri, 23 May 2014 05:40:03 GMT

Hello!

I have the following two tables in my application:

Table 1:

Quantities (#)	Total Sent	Anomaly	No Anomaly	Completed	Pending
Zone A	100	30	60	90 =30+60	10 =100-90
Zone B	50	10	25	35 =10+25	15 =50-35

Quantities (#)

Total Sent

Anomaly

No Anomaly

Completed

Pending

Zone A

100

=30+60

=100-90

Zone B

=10+25

=50-35

Table 2:

Quantities (%)	Total Sent	Anomaly	No Anomaly	Completed	Pending
Zone A	100	33% =30/90*100	67% =60/90*100	90% =90/100*100	10% =100%-90%
Zone B	50	29% =10/35*100	71% =25/35*100	70% =35/50*100	30% =100%-70%

Quantities (%)

Total Sent

Anomaly

No Anomaly

Completed

Pending

Zone A

100

33%

=30/90*100

67%

=60/90*100

90%

=90/100*100

10%

=100%-90%

Zone B

29%

=10/35*100

71%

=25/35*100

70%

=35/50*100

30%

=100%-70%

Is there any way to use in table 2 results from expressions calculated in table 1?

In order to not calculate the same thing both times... Or it is not possible to do that?

Maybe if I create a single table with all the data, it would be easier?

What do you recommend?

Thank you!!!

Re: Using Expressions from Another Table?

anbu1984 — Fri, 23 May 2014 05:47:30 GMT

You have to create single table with all data

Re: Using Expressions from Another Table?

SunilChauhan — Fri, 23 May 2014 05:53:39 GMT

use variable in expression for first table

and use that variable for calculation in second table

hope this helps

topic Re: Using Expressions from Another Table? in QlikView

Using Expressions from Another Table?

Re: Using Expressions from Another Table?

Re: Using Expressions from Another Table?