topic Re: Get Min/Max of a expression in QlikView

Get Min/Max of a expression

diegodelacruz — Sat, 16 Nov 2024 01:30:03 GMT

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.

Re: Get Min/Max of a expression

Vegar — Wed, 15 Jan 2020 22:42:17 GMT

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 ];

Re: Get Min/Max of a expression

Lisa_P — Thu, 16 Jan 2020 00:44:09 GMT

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

Re: Get Min/Max of a expression

Brett_Bleess — Wed, 12 Feb 2020 21:48:45 GMT

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