Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Vittore8
Creator
Creator

Group BY Year Aggr Help

Vittore8_0-1589395488899.png

Hi,please tell me how to get this result

2015 3
2016 1
2017 3

and return 2016 because it occurs 1 time

Labels (1)
2 Replies
FruzoCrew
Creator
Creator

Please use,

Front end script :

count(Year) or sum(value)  (b'cos in your case value is 1)

Back end:

Load Year, count(Year)

resident table

group by Year;

AdiPai
Creator II
Creator II

 

 

Try this 

LOAD * INLINE [
Year,Value
2015,1
2015,1
2015,1
2016,1
2017,1
2017,1
];

 

 

 

FirstSortedValue(Year,AGGR(Count(Value),Year))