topic Re: Using Expressions from Table1 in Table2 in QlikView

Using Expressions from Table1 in Table2

Mon, 02 Jun 2014 05:09:56 GMT

Hello!

I have the following two tables:

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

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%

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 Table1 in Table2

its_anandrjs — Mon, 02 Jun 2014 05:33:10 GMT

Use expressions for this in the table2

Eg:-

Let vAnomaly = Expression for Anomaly from table1

Let vNoAnomaly = Expression for No anomaly table1

Let vCompleted = Expression for Completed table1

Table2 Calculation

Anomaly = $(vAnomaly)/90*100

No Anomaly = $(vNoAnomaly)/$(vCompleted)*100

Other like the same.

Re: Using Expressions from Table1 in Table2

Mon, 02 Jun 2014 05:59:51 GMT

Hi,

It will be good if you create single table and after that calculations, I think in single table calculations will get fast and reduce the reload time also.

Re: Using Expressions from Table1 in Table2

PradeepReddy — Mon, 02 Jun 2014 06:04:56 GMT

Hi,

It is better and easy to create a single table, instead of 2 tables. By doing this we can reduce one object in our report.
So that the perfprmance will be improved.

Re: Using Expressions from Table1 in Table2

jagan — Mon, 02 Jun 2014 06:06:39 GMT

Hi,

The expressions used in one chart (table) is not possible to use in another charts. You can do this in script and use the new calculated columns in the front end.

Regards,

Jagan.

Re: Using Expressions from Table1 in Table2

sasikanth — Mon, 02 Jun 2014 06:09:02 GMT

Hi mart

use single table instead of two tables , you can calculate remainin exp based on previous columns

or else

use variables i,e create variables and store these exp into variables ,

then you can call it where ever you want , this is also good, reusing exp .

Regards

sasi