topic Re: Set analysis and date dimension in QlikView

Set analysis and date dimension

Thu, 10 Oct 2013 08:44:25 GMT

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.

Re: Set analysis and date dimension

tresB — Thu, 10 Oct 2013 08:49:43 GMT

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

Re: Set analysis and date dimension

Gysbert_Wassenaar — Thu, 10 Oct 2013 08:56:09 GMT

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.

Re: Set analysis and date dimension

Fri, 11 Oct 2013 06:34:54 GMT

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

・・

Re: Set analysis and date dimension

Gysbert_Wassenaar — Fri, 11 Oct 2013 10:11:50 GMT

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