Set analysis and date dimension

[#1]

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.

[tresesco]

It seems that basically you need help on date range selection, if so, PFA.

[Gysbert_Wassenaar]

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.

[#4]

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

・・

[Gysbert_Wassenaar]

Perhaps my answer here helps: User login count using set analysis and weekday