topic Re: How to set gauge limits based on row? in QlikView

How to set gauge limits based on row?

Wed, 09 May 2012 15:47:35 GMT

Here's a sample table:

Game	Player	Points
1	Michael Jordan	27
1	Larry Bird	31
2	Michael Jordan	42
2	Larry Bird	21
3	Michael Jordan	35
3	Larry Bird	25

I have Michael Jordan and Larry Bird in a straight table that has a column for their name, and a column for a gauge on the average amount of points.

I want a gauge for each player.

I want the gaugages for each player to be segmented with the limits of 0, min(Points), max(Points).

However, the problem is, it's choosing the min and max values for BOTH players so the min and max for BOTh is 21 and 42. I want it to be 27 and 42 for Michael Jordan, 21 and 31 for Larry Bird.

Any ideas on how I can write this expression so it finds the minimum based on Player and not the entire data set?

How to set gauge limits based on row?

jykang0638 — Wed, 09 May 2012 16:16:01 GMT

You can achieve your goal using set analysis.
For Michael Jordan, Min({<Player={'Michael Jordan'}>} Points), Max({<Player={'Michael Jordan'}>} Points)
For Larry Bird, Min({<Player={'Larry Bird'}>} Points), Max({<Player={'Larry Bird'}>} Points)

Set Analysis is very powerful. Refer to reference manual.

I hope it helps you.

Steve Kang.

How to set gauge limits based on row?

Wed, 09 May 2012 16:17:58 GMT

Hello, is there a way to do this without having to identify the Player in the expression?

My data set is actually thousands of players, and I am attempting to do this in table format rather than creating a separate gauge for each individual player. Thank you for the assistance.

Re: How to set gauge limits based on row?

jykang0638 — Wed, 09 May 2012 17:05:07 GMT

Oh, I see.
If you add Player as dimension with other fields, you can use TOTAL keyword in your expression.
Like this: Min(TOTAL <Player> Points)
It's similar to group by clause in SQL.
If you can, refer attached qvw.

Steve Kang.