topic Re: Difference between all the Selected values columns in Straight Table in QlikView

Difference between all the Selected values columns in Straight Table

dondapati — Sat, 16 Nov 2024 01:38:56 GMT

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

Re: Difference between all the Selected values columns in Straight Table

Taoufiq_Zarra — Fri, 20 Dec 2019 15:40:01 GMT

HI,

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

share your qlikview file or samplel data to see clearly

Re: Difference between all the Selected values columns in Straight Table

dondapati — Fri, 20 Dec 2019 17:06:13 GMT

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.

Re: Difference between all the Selected values columns in Straight Table

Brett_Bleess — Thu, 26 Dec 2019 15:27:57 GMT

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/InterRecordFunctions/column.htm

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

Regards,
Brett