Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Use column value in set analysis

I have a detail list where I calculate the column "Division owner" with

=FirstSortedValue({$<Portal_Division_Name=, Division=,DivisionInternalName=,DivisionName=,Portal_Division=>}Division,-Aggr(sum({$<Portal_Division_Name=, Division=,DivisionInternalName=,DivisionName=,Portal_Division=>}LineAmount_EUR),Division,[Supplier number]))

And now I want to use the value in this column "Division owner" to get the value for Purcahser in my set analysis

I have tried both

=MinString({$<Division={'[Division owner]'}>}Purchaser)

and

=MinString({$<Division={$(=[Division owner])}>}Purchaser)

1 Solution

Accepted Solutions
sunny_talwar

May be this:

=MinString({$<Division={"=Division = FirstSortedValue({$<Portal_Division_Name=, Division=, DivisionInternalName=, DivisionName=, Portal_Division=>}Division,-Aggr(Sum({$<Portal_Division_Name=, Division=, DivisionInternalName=, DivisionName=, Portal_Division=>}LineAmount_EUR), Division, [Supplier number]))"}>} Purchaser)

View solution in original post

3 Replies
sunny_talwar

May be this:

=MinString({$<Division={"=Division = FirstSortedValue({$<Portal_Division_Name=, Division=, DivisionInternalName=, DivisionName=, Portal_Division=>}Division,-Aggr(Sum({$<Portal_Division_Name=, Division=, DivisionInternalName=, DivisionName=, Portal_Division=>}LineAmount_EUR), Division, [Supplier number]))"}>} Purchaser)

Not applicable
Author

I thought I tried it, but must have missed something. Thanks!

sunny_talwar

No problem at all