Show Only Max Value

[adambrian]

Hi,
I new in qlik sense, can someone help me to show max value in every State which in Bar Graph. What expression I should put in dimension and measure. I want to show all state in bar graph.

Category,State,AfterCount(PeopleId)

1,A,12

2,A,32

3,A,19

4,A,24

1,B,24

2,B,9

3,B,15

4,B,19

1,C,21

2,C,33

3,C,17

4,C,11

Expected result in every State :

2,A,32

1,B,24

2,C,33

[rahulpawarb]

Hello Adam,

Trust that you are doing great!

Please refer below given sample script to get the desired result:

Data:
LOAD * INLINE [
Category,State,AfterCount(PeopleId)
1,A,12
2,A,32
3,A,19
4,A,24
1,B,24
2,B,9
3,B,15
4,B,19
1,C,21
2,C,33
3,C,17
4,C,11
];
INNER JOIN 
LOAD State,
     Max([AfterCount(PeopleId)]) AS "AfterCount(PeopleId)"
Resident Data
Group By State;

Hope this will be helpful.

Regards!

Rahul

[adambrian]

Thank a lot rahulpawarb

if i want to change it to map, how can we do it. i want color of state by max category.. do you know to do it?

[rahulpawarb]

Thank you Adam for validating it.

Could you please share more details about your requirement? This will help us to understand the requirements and provide you required inputs.

Regards!

Rahul

[kkkumar82]

I think you can use ColorMix function for such things

[adambrian]

Hi rahulpawarb,

What I want in map is i want to set color based on State of area which Max([AfterCount(PeopleId)]). Like example you did in bar graph, but i convert to area map. Sorry if you dont understand what i am telling. my english is very bad.

[adambrian]

Hi kkkumar82‌,

Can you tell me how to use ColorMix in AreaMap base on max value Category in every State. Sorry if my details is not very clear.