Discussion Board for collaboration on QlikView Scripting.
I have 2 columns. Based on data in column 1, I need to do a working on column 2.
1st row has District '1' with value as 200.
I need to add another column which takes minimum of all the values against '1' and subtracts that from Value in the 1st row.
In this case, Column 3 = 200 - min (all values against 1) = 200-100 = 100
Any help is very much appreciated.
Go to Solution.
The attached application gives a solution.