Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi, are you learning QlikView are working with ? i need some suggestions regarding this one..
Hi
am attaching qvw, hopping it may be helpfull
-Regards
Premhas
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
I am learning qlikview.
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
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];
(inner join cheyi)
inner join both the tables
Inner join kadu. 2 separate list of users ravali. N from them I should get common data.
can i get the samething you had specified in script?