Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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


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

17 Replies
Anonymous
Not applicable
Author

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

preminqlik
Specialist II
Specialist II

Hi

am attaching qvw, hopping it may be helpfull

-Regards

Premhas

Not applicable
Author

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

Not applicable
Author


I am learning qlikview.

preminqlik
Specialist II
Specialist II

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

Not applicable
Author


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
Specialist II
Specialist II

(inner join cheyi)

inner join both the tables

Not applicable
Author

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

Not applicable
Author

can i get the samething you had specified in script?