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]

So these tables are not linked in your data model at all? That's quite unusual.

If you can't change this, you can try something like

=Max([SLA]) - Min({<INT_ID = {'$(=Only({<[SLA] = {"$(=Max([SLA]))"}>} INTF_ID))'}>} [Receptpion value])

[#3]

Hi Swehul,

But the $ thing is going to do selction right , We want to do for all values.

[swuehl]

Then please start with a more complete description of your setting and requirements, best by uploading a small sample file or modification of the sample I've provided.

Add a description / Excel with the expected results.

[sdmech81]

Hi,

1)Hope, Stefans set should give u correct value.In case u want to perform aggregation on entire set then replace $ with 1 and check.

2)But when u already have 2 tables with common key, why cant u bring them in one table by doing applymap and fetch the result as we denormalize to create fact in qlikview.It should not be causing perf problem.share table viewer.

-sachin