topic Re: Row Wise difference in QlikView in QlikView

Row Wise difference in QlikView

dondapati — Mon, 26 Jan 2026 18:19:17 GMT

Hi QlikView Experts,

Good Day

I am new to Qlikview Software, I am very much grateful if, give the solution/idea to the following Problem.

I want to find the Difference row wise based on the selection from Dimension(Here Dimension is Pr-Column).

Here Selection Dynamically ,so based on the selection all possible Combination of Differences is generate.

Here data looks like

Input
BO	Pa	As	To	Pr
6	52	10	68	AA
11	25	13	49	BB
23	14	17	54	cc

My Output Format is

Output
BO	Pa	As	To	Pr
-5	27	-3	19	AA-BB
-17	38	-7	14	AA-cc
-12	11	-4	-5	BB-cc

If i select Only AA from the Pr Column no Differences will come if Select more than one all the possible Combination Differences will be generate

Re: Row Wise difference in QlikView

Brett_Bleess — Mon, 10 Feb 2020 21:44:03 GMT

Best I can do is recommend you attach a sample QVW if you have one with your data model, as that generally makes it easier for folks to try to help with suggestions, but the other thing you can do here is use the Design Blog area to search for something that may be helpful there. I am not exactly sure what you are trying to do, so I am just going to give you the base URL, and you can search yourself to see if you can find anything helpful. There are 700+ mostly how-to posts in this area from our own experts, so hopefully you can find something to get you on your way.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett