topic Get value in Table A based on another Table B in QlikView

Get value in Table A based on another Table B

Tue, 18 Jun 2013 14:46:31 GMT

Hello Friend,

I have two tables as follow.

Table A:

Table B:

Here Table A is master data.

I want to get expected result value in Table B based on Table A (Master Table) Point from and To.

for Ex.

Table B: Calculated Point = 55, Expected result = 30

Table B: Calculated Point = 20, Expected result = 10

Table B: Calculated Point = 74, Expected result = 30

Please let me know any solution.

Thanks

Tue, 18 Jun 2013 14:50:53 GMT

as far as i remember "interval match" function should solve the problem.

if not try "class"

best regards

chris

prodanov — Tue, 18 Jun 2013 14:58:17 GMT

This is a script for IntervalMatch

Anonymous — Tue, 18 Jun 2013 15:32:20 GMT

Hi Dipak

Create a Chart and use the following expression in that

=if((CALCULATEDPOINT>POINTFROM And CALCULATEDPOINT<POINTTO),VALUE)

please find the below attachment

Regards

Harsha