Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
krishna_venkata
New Contributor II

Account Activation Stats help required

Hi Experts , i need some help to get a table like this. but acheiving this seems to be going a bit far.

i have new accounts and its details of date opened etc in a text file. The transactions file (huge huge) has huge pile of transactions since the account creation date. i am looking for statistics of the current month accounts opened and the activated account below talks about atleast 1 transaction of the opened account in the specified month.

for ex : in the month of january, 91/103 have used and rest not made any transaction.


i am trying to put this in QVW but not getting the right logic to build this.

for the activated account, i am looking for the first occurence of the transaction and counting as 1.  i have attached my QVW, i tried using the min (transaction date) to get the first occurence  and even tried few combinations around firstsortedvalue or allocate a key using autonumberhash256. no results yet. might be complicating my self.

Month AcquiredOpened AccountsActivated Account% Activated
Jan1039188%
Feb22521093%
Mar27223486%
Apr14412688%
May2589637%
Total100275776%
Community Browser