topic Re: Re: overall date in QlikView

overall date

Tue, 03 Sep 2013 11:16:18 GMT

I have table 'users' with fields: [user_id], [login], [user_date_register]...

Also i have table 'transactions' with fields: [transaction_id], [user_id], [transaction_date], [sum] ...

I need to make report as:

Date	Count_of_users	Count_of_transactions	Count_of_users/Count_of_transactions
....	...	...	...

How i may make it?

Re: overall date

ariel_klien — Tue, 03 Sep 2013 11:42:21 GMT

if the main date is the transaction_date do like this:

users:

Load [user_id],

[login],

[user_date_register],

...

from ....

transactions:

load [transaction_id],

[user_id],

[transaction_date] as Date,

[sum]

from ....

then in the chart put in the dimension Date

and in the expression put:

count([user_id]) as count_of_users

count([transaction_id]) as count_of_transactions

count([user_id])/count([transaction_id])

Ariel

Re: overall date

Tue, 03 Sep 2013 11:46:52 GMT

Date in this report is common for transactions and user registrations. I need calculate count of users on service per date and count of transactions in this date.

sample of table 'users':

user_id	login	user_date_register
1	hh	01-01-2012
2	tt	01-02-2012
3	pp	01-02-2012
4	oo	01-03-2012

sample of table 'transactions'

transaction_id	user_id	transaction_date	sum
1	1	01-01-2012	20
2	1	01-01-2012	30
3	2	01-02-2012	15
4	1	01-02-2012	15
5	3	01-02-2012	6
6	4	01-03-2012	23
7	4	01-03-2012	14
8	2	01-03-2012	18

than report is

Date	Count_if_users	Count_of_transactions	Count_of_transactions/Count_if_users
01-01-2012	1	2	2
01-02-2012	3	3	1
01-03-2012	4	3	0,75

Re: Re: overall date

Tue, 03 Sep 2013 12:13:20 GMT

Hey to solve a similar problem i used the approch that you can find in this QVW.

See attached file

Re: Re: overall date

Tue, 03 Sep 2013 15:29:50 GMT

I don't see attached files. Can you send it to me (inter-proger@yandex.ru) or post it here again?