Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

overall date

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:

DateCount_of_usersCount_of_transactionsCount_of_users/Count_of_transactions
.............

How i may make it?

4 Replies
ariel_klien
Specialist
Specialist

Hi

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])


BR


Ariel

Not applicable
Author

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_idloginuser_date_register
1hh01-01-2012
2tt01-02-2012
3pp01-02-2012
4oo01-03-2012

sample of table 'transactions'

transaction_iduser_idtransaction_datesum
1101-01-201220
2101-01-201230
3201-02-201215
4101-02-201215
5301-02-20126
6401-03-201223
7401-03-201214
8201-03-201218

than report is

DateCount_if_usersCount_of_transactionsCount_of_transactions/Count_if_users
01-01-2012122
01-02-2012331
01-03-2012430,75
Not applicable
Author

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

See attached file

Not applicable
Author

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