grouping in qlikview

[#1]

can we get count of users grouping by some feild  in qlikview and display it in bar chart?

If so what are the ways to do grouping? can anyone explain me with some example

[michael_maeuser]

generally you automatically group if you add the field as dimension you want to group by

[#3]

what is the use of aggr() function? in which case we can use that?

[neetu_singh]

Hi,

Aggr() function will aggregate over the set of possible records defined by selection.

Eg: if you want count of people with respect to country so you can use

aggr(count(user),Country)

or

aggr( distinct count(user),Country)

[#5]

how can we display them in a bar chart?

[#6]

how can we display them in a bar chart?

[#7]

my requirment says something like this

We will have to identify the users who have been at same location together for 80% of the times during the day. Based on this the output for this will be N number of groups of users who stay together.

so they are saying like, i had to group based on location and time.  had to display in a chart finally

my feilds are like this.

username location timestamp.

Any approach how to do this?

[neetu_singh]

Hi,

in bar chart you can get easily, add your field as dimension and in expression simply write count(user)

[#9]

hi neetu,

I had posted my req. can u explain me how can we do that?

[neetu_singh]

Hi,

can you attach some sample data or you can try by adding location nd timestamp at dimension and count(username) in expression.