Calculated Values away from Dimensions Used

Venkatesh11789 — Mon, 27 Feb 2023 11:50:12 GMT

Team, I have a data in Table 1 like below.

Doing from calculation based on a Variable captured in the screen from User for each Doc No and calculating a percentage like in Table 2, which i can able to calculate.

I need to apply the Table 2 Percentage in Table 1 again and create Table 3 which I cant able to.

Can I somehow maintain a column away from the Dimensions used?

Or I can do a lookup from another calculated table? I cannot use load script as i have a user input variable in the calculation.

Doc No	Entity Code	Ori Amount	Curr Amount
P1	Cust A	1000	500
P1	Cust B	-500	-450
P1	Cust C	-200	-150
P2	Cust D	-500	-200
P2	Cust E	640	250

Table 2:

Doc No	Perc
P1	25%
P2	50%

Table 3:

Doc No	Entity Code	Ori Amount	Ori Amt Perc
P1	Cust A	1000	250
P1	Cust B	-500	-125
P1	Cust C	-200	-50
P2	Cust D	-500	-250
P2	Cust E	640	320

Re: Calculated Values away from Dimensions Used

rui24 — Mon, 27 Feb 2023 12:35:56 GMT

Hello @Venkatesh11789

I think I fix your problem.

The expression to put in the field in the tabel:

=if([Doc No] = 'P1',[Ori Amount] * 0.25,[Ori Amount] * 0.50)

The name of the label:

Ori Amt Perc

In the following prints you can see what have I done

topic Calculated Values away from Dimensions Used in QlikView

Calculated Values away from Dimensions Used

Re: Calculated Values away from Dimensions Used