Comparison Of Values

[#1]

Hi Team,

I have  a requirement where in TAble A i have values 1,2,3,4, and i have Table B with values 5,6,7,8

Now i need the maximum difference of the values when i do difference values of Table B - Table A. How do i attain that using Qlikview .

And also can any one guide me to set analysis if we can use here and any referencing link

[swuehl]

Not sure how these tables are related and based on which relation you want to compare your values.

Maybe just join both tables by record number:

LOAD Recno() as RecID,

          ValueA

FROM TableA;

JOIN

LOAD Recno() as RecID,

         ValueB

FROM TableB;

Then you can calculate the max difference in a text box like

=Max( fabs( ValueA - ValueB) )

[ramasaisaksoft]

Hi Bharat,

we are unable to understand your query.

as per my understanding i think u need to subtract values from

=aggr((field b-field a),some join key ex:-product no)

please correct me with sample data and Expected out put ,if understand wrongly.

[avinashelite]

Hi Rama,

Please share the sample data and the excepted output , so that it will helps to understand better

[sdmech81]

Hi,

qsn is bit confusing.You want to show that max difference in text box ??

If that is the case then fetch min(table 1) and Max(table 2) and then deduct the 2.

if in table please elaborate it..

--sachin

[#6]

Hi Thanks for that , but let me rephrase my question in clear way . We have Column 2 common in both tables .

FILE_T ( Table 1)                                                INTERF_T( Table 2)

SLA (Column1)  INTF_ID ( Column2 )               Receptpion value ( Column 1)   INT_ID (Column2)

15                   1                                               10                                   1

25                  2                                                20                                   2

35                  3                                                30                                   3

45                  4                                                39                                   4

I would like to get that Reception value where SLA-Reception value has the max value ,

For the above given Ex: max (SLA-Reception value ) is  45-39 =6. So Finally we need the Reception value associated with the max difference. In this case its is 39 .

[#7]

Hi Thanks for that , but let me rephrase my question in clear way . We have Column 2 common in both tables .

FILE_T ( Table 1)                                                INTERF_T( Table 2)

SLA (Column1)  INTF_ID ( Column2 )               Receptpion value ( Column 1)   INT_ID (Column2)

15                   1                                               10                                   1

25                  2                                                20                                   2

35                  3                                                30                                   3

45                  4                                                39                                   4

I would like to get that Reception value where SLA-Reception value has the max value ,

For the above given Ex: max (SLA-Reception value ) is  45-39 =6. So Finally we need the Reception value associated with the max difference. In this case its is 39 .

[#8]

Hi Thanks for that , but let me rephrase my question in clear way . We have Column 2 common in both tables .

FILE_T ( Table 1)                                                INTERF_T( Table 2)

SLA (Column1)  INTF_ID ( Column2 )               Receptpion value ( Column 1)   INT_ID (Column2)

15                   1                                               10                                   1

25                  2                                                20                                   2

35                  3                                                30                                   3

45                  4                                                39                                   4

I would like to get that Reception value where SLA-Reception value has the max value ,

For the above given Ex: max (SLA-Reception value ) is  45-39 =6. So Finally we need the Reception value associated with the max difference. In this case its is 39 .

[#9]

Hi Thanks for that , but let me rephrase my question in clear way . We have Column 2 common in both tables .

FILE_T ( Table 1)                                                INTERF_T( Table 2)

SLA (Column1)  INTF_ID ( Column2 )               Receptpion value ( Column 1)   INT_ID (Column2)

15                   1                                               10                                   1

25                  2                                                20                                   2

35                  3                                                30                                   3

45                  4                                                39                                   4

I would like to get that Reception value where SLA-Reception value has the max value ,

For the above given Ex: max (SLA-Reception value ) is  45-39 =6. So Finally we need the Reception value associated with the max difference. In this case its is 39 .

[#10]

Having said that i would to mention one more thing ,that our query is already complex with Joins . I dont want to write a join , rather i would like the comparison to be handled in Qlikview.