topic Re: grouping in qlikview in QlikView

grouping in qlikview

Wed, 04 Sep 2013 11:51:10 GMT

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

Re: grouping in qlikview

michael_maeuser — Wed, 04 Sep 2013 11:53:55 GMT

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

Re: grouping in qlikview

Wed, 04 Sep 2013 12:08:41 GMT

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

Re: grouping in qlikview

neetu_singh — Wed, 04 Sep 2013 12:16:57 GMT

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)

aggr( distinct count(user),Country)

Re: grouping in qlikview

Wed, 04 Sep 2013 12:25:53 GMT

how can we display them in a bar chart?

Re: grouping in qlikview

Wed, 04 Sep 2013 12:25:56 GMT

how can we display them in a bar chart?

Re: grouping in qlikview

Wed, 04 Sep 2013 12:29:40 GMT

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?

Re: grouping in qlikview

neetu_singh — Wed, 04 Sep 2013 12:30:22 GMT

Hi,

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

Re: grouping in qlikview

Wed, 04 Sep 2013 12:41:21 GMT

hi neetu,

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

Re: grouping in qlikview

neetu_singh — Wed, 04 Sep 2013 13:11:26 GMT

Hi,

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

Re: grouping in qlikview

michael_maeuser — Wed, 04 Sep 2013 13:18:28 GMT

i´m not an expert in statisctical topics, but search in your qv help for statistical aggregation. maybe the expression correll might help you.

Re: grouping in qlikview

Thu, 05 Sep 2013 11:06:34 GMT

hi neetu,

my data is sumthin like this.

n1 u1 3.00

n2 u2 4.00

n3 u2 3.00

n4 u3 5.00

n1 u4 6.00

n2 u1 4.00

n3 u3 5.00

n4 u2 6.00