Difference between all the Selected values columns in Straight Table

[dondapati]

Hi all, I have the following straight Table, with a dimension of company, and expressions are val1, val2, val3 and i want to know how to calculate the difference between companies automatically. How do i do that? 

Based on the selection of company(List box) then difference will find out ,here Company values are Dynamically selected from the list box

Input :

company	a(a1)	b(b1)	c(c1)
val1	12	10	15
val2	10	15	23
val3	14	12	11

Required Output:

company	a(a1)	b(b1)	c(c1)	a(a1) Vs b(b1)	a(a1) Vs c(c1)	b(b1) Vs c(c1)
val1	12	10	15	2	-3	-5
val2	10	15	23	-5	13	-8
val3	14	12	11	2	3	1

[Taoufiq_Zarra]

HI,

normally it's just a simple: fields minus fields.

share your qlikview file or samplel data to see clearly

[dondapati]

Hi ZaRRA , Thank you for You'r Response 

I am selecting from the Company names  list ,

Depends on the selection , the combinations of the difference will be generate , in the output.

Here i am selecting only 3 company names ,so the combinations will be 6 . if select more than that with respect combination of the differences will be generate .

I hope explained clearly.

[Brett_Bleess]

Check out the following Help link, may work, but I am not certain:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

This only works in a Straight Table chart, just FYI.

Regards,
Brett