Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
diegodelacruz
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

Screenshot_1.png

 

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
Highlighted
Partner
Partner

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. 

image.png

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
Highlighted
Employee
Employee

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

Highlighted
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.

Regards,
Brett

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.