get the list of users in a network based on earliest timestamp

[#1]

hi,

I had some datase like below

load * inline

[networkid, user, timestamp

n1,u1,1

n1,u2,2

n1,u3,3

n2,u1,2

n2,u2,3

n2,u3,1

n3,u1,3

n3,u2,2

n3,u3,1

n2,u1,3

n1,u1,3];

now i need to get the list of users who are in a network at highest time

something as below.

networkid               timestamp               users

n1                                   3                         u1,u3

n2                                    3                          u2,u1

please help me how to acheive this

[Anonymous]

Hi, are you learning QlikView are working with ? i need some suggestions regarding this one..

[preminqlik]

Hi

am attaching qvw, hopping it may be helpfull

-Regards

Premhas

[#4]

can you please post here how you did this? i qm working on personal edition and i cannot open your file. so, please post the content

[#5]

I am learning qlikview.

[preminqlik]

hmm ok ,

1.  open one pivot , select network id ,user as a dimension

2. expression as max({$*maxb}timestamp)

3. create one button

4.add action >> select field>> fieldname : NetworkId>> field value >>=max(Timestamp)

5.save book mark as maxb

any doubts

ping me on skype : endlessprem

regards

prem

[#7]

hi,

Thank you for your reply. in the actual scenario, i had multiple tables like this with difference in timestamps.

I need to get the common users in both of the tables based on networkid.

Can you help me how to do this?

Table1:

  load * inline  [networkid, user, timestamp  n1,u1,1  n1,u2,2  n1,u3,3  n2,u1,2  n2,u2,3  n2,u3,1  n3,u1,3  n3,u2,2  n3,u3,1  n2,u1,3  n1,u1,3]; 

Table2:

  load * inline  [networkid, user, timestamp  n1,u1,4  n1,u2,5  n1,u3,6  n2,u1,5  n2,u2,6  n2,u3,4  n3,u1,6  n3,u2,5  n3,u3,4  n2,u1,6  n1,u1,6];

[preminqlik]

(inner join cheyi)

inner join both the tables

[#9]

Inner join kadu. 2 separate list of users ravali. N from them I should get common data.

[#10]

can i get the samething you had specified in script?