Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Help regarding aggregation

I have 2 columns. Based on data in column 1, I need to do a working on column 2.

For example,

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

DistrictValueTo do in qlikview
1200100B2-minimum of all values against 1.
22000B3-minimum of all values against 2
11000B4-minimum of all values against 1
2300100
1300200
115050
1400300

Any help is very much appreciated.

Regards

Raghav

1 Solution

Accepted Solutions
nagaiank
Valued Contributor III

Re: Help regarding aggregation

The attached application gives a solution.

1 Reply
nagaiank
Valued Contributor III

Re: Help regarding aggregation

The attached application gives a solution.

Community Browser