Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Re: Change color of 2nd dimension based on max value on 1st dimension

This will work:

=If(Aggr(sum(StandardCost), EnglishProductCategoryName, EnglishProductSubCategoryName, EnglishProductName) = max(total<EnglishProductCategoryName> Aggr(Sum(StandardCost), EnglishProductCategoryName, EnglishProductSubCategoryName, EnglishProductName)), Yellow())

Not applicable

Re: Change color of 2nd dimension based on max value on 1st dimension

And it did work. Splendid!

Just a quick question on total<EnglishProductCategoryName>...why shall we use a dimension after Total in the above scenario?