Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
cwitman1
New Contributor III

Combining Values to Unique User

Is there a way I can combine values to for a Unique User.

Ex. Table of  User by Total MB Downloaded

What I have:

UserDomainMB_Downloaded
Chris WGoogle100
Bob FYahoo50
Chris WAol25
Tom JAol25
Bob FAol10
Tom JYahoo5

What I want:

UserDomainMB_Downloaded
Chris WGoogle, Aol125
Bob F Yahoo, Aol60
Tom JAol, Yahoo30

Is there a way I can do this in Data load? or anyway to get this?

1 Solution

Accepted Solutions

Re: Combining Values to Unique User

Here is a sample script using Inline load

Table:

LOAD User,

    Concat(DISTINCT Domain, ', ', RecNo()) as Domain,

    Sum(MB_Downloaded) as MB_Downloaded

Group By User;

LOAD * INLINE [

    User, Domain, MB_Downloaded

    Chris W, Google, 100

    Bob F, Yahoo, 50

    Chris W, Aol, 25

    Tom J, Aol, 25

    Bob F, Aol, 10

    Tom J, Yahoo, 5

];

Capture.PNG

View solution in original post

4 Replies
jaceknoden
Contributor

Re: Combining Values to Unique User

Hello Chris

Try this as expresion:

=aggr(sum(MB_Downloaded),User)

Regards

Jacek.

Re: Combining Values to Unique User

Sure, try this while loading....

LOAD User,

     Concat(DISTINCT Domain, ', ') as Domain,

     Sum(MB_Downloaded) as MB_Downloaded

FROM....

Group By User;

Re: Combining Values to Unique User

Here is a sample script using Inline load

Table:

LOAD User,

    Concat(DISTINCT Domain, ', ', RecNo()) as Domain,

    Sum(MB_Downloaded) as MB_Downloaded

Group By User;

LOAD * INLINE [

    User, Domain, MB_Downloaded

    Chris W, Google, 100

    Bob F, Yahoo, 50

    Chris W, Aol, 25

    Tom J, Aol, 25

    Bob F, Aol, 10

    Tom J, Yahoo, 5

];

Capture.PNG

View solution in original post

atkinsow
Valued Contributor II

Re: Combining Values to Unique User

Here you go.