Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm new to Qlikview.
I would appreciate any help with the following issue.
I have one table for User login information like as below:
LoginTime UserID
2013-10-10 00:00:00 UserA
2013-10-10 11:11:11 User A
2013-10-11 22:22:22 User B
・・・
I want to count daily login counts per User within selected date period.
I made two dimension.
First day(LoginTime),
Second aggr(count(UserID & day(LoginTime)).
I made one expression.
count(distinct UserID ).
And I select a certain days on Calendar of LoginTime.
Then the result is
Counting all login count within this period not daily for daily login UserID.
It looks daily login count. But this counts daily login User's all login counts within this period.
Thanks in advance,
Tomoaki.
It seems that basically you need help on date range selection, if so, PFA.
If you want to see the login count per user per day then you need to use two dimensions, i.e. day and user. And count(UserID) as expression. Count(distinct UserID) will return 1 if you use day and user as dimensions.
Thanks!
two dimensions: UserID and day work well.
I have one more question.
I want to count UserIDs per login count volume group each day.
My output image is :
LoginDay LoginCountGroup UserIDCount
2013-10-9 10 200
2013-10-9 9 400
2013-10-10 9 300
2013-10-10 8 500
・・
Perhaps my answer here helps: User login count using set analysis and weekday