Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

New Contributor

Get Min/Max of a expression

Hello people,

I hope you can help me with a solution. I've been working over a week without a success result.

I am trying to show a pivot table with three dimensions and three expressions.

Dim: Country, City, Brand.

Exp: Total Sale, Minimum Sale, Maximun Sale.

I need to get a pivot table just like this



So far, I've got the max/min value in one cell of each group, but I need those values in all group cells.


3 Replies

Re: Get Min/Max of a expression

I see two ways to solve this by epressions. Either by an aggr(nondistinct min()) or a min(total <>) .


Screenshot and script is from the attached qvw file. 


LOAD * inline [
Country, City, Brand, Sales
Norway, Trondheim, B1, 558
Norway, Trondheim, B2, 117
Sweden, Vimmerby, B1, 790
Sweden, Stockholm, B1, 747
Sweden, Stockholm, B2, 601
Sweden, Stockholm, B3, 554


Plees ekskuse my Swenglish and or Norweglish spelling misstakes

Re: Get Min/Max of a expression

The pivot table should do this easily.

Country, City and Brand as dimensions

Sum(Sale), Min(Sale), Max(Sale) as expressions

Expand Country and City columns

Digital Support
Digital Support

Re: Get Min/Max of a expression

If Vegar or Lisa's posts helped you with things, please be sure to return to the thread and use the Accept as Solution button on the post(s) that got you what you needed, this closes out the thread, gives the posters credit for the help and lets other Members know what worked, so please be sure you complete this step on your posts rather than leaving them open...  If you are still working on things, please leave an update for us on what you still need help solving.


To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.