Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

navaskhan
New Contributor II

Calendar for Creation Date,Last Login Date,Transaction Date

i have requirement to create dashboard for user activity.

Data is as below :

User Table : User ID,Create Date, Login Date

Transactions : Transaction Date ,User ID

How create the Calendar to Link Date wise User Created / Logins & Transaction

3 Replies

Re: Calendar for Creation Date,Last Login Date,Transaction Date

Try this?

UserTable:

Load [User ID],

     [Create Date] as DateField,

     'Create Date' as Flag

From <Data Source>;

Concatenate (UserTable)

Load [User ID],

     [Login Date] as DateField,

     'Login Date' as Flag

From <Data Source>;

Join (UserTable)

Transactions:

Load [Transaction Date] as DateField,

     'Transaction Date' as Flag,

     [User ID]

From <Data Source1>;

LinkTable:

Load AutoNumber([User ID] & '|' & DateField) as %Key Resident UserTable;

Concatenate (LinkTable)

Load AutoNumber([User ID] & '|' & DateField) as %Key Resident Transactions;

Drop Fields [User ID], DateField From UserTable;

Drop Fields [User ID], DateField From Transactions;

Rename Field DateField to Date;

luismadriz
Valued Contributor

Re: Calendar for Creation Date,Last Login Date,Transaction Date

Hi Anil,

I'm keen to learning more about the LinkTable:

If you don't mind, how does the data model should look like after this load script?

Should it be something like this?

Untitled.png

Thanks,

Luis

Highlighted

Re: Calendar for Creation Date,Last Login Date,Transaction Date

Sure, Usually when i start surf "Use of Link Table". I got link and same from Deepak. You may liked it and better understand

https://www.analyticsvidhya.com/blog/2014/12/remove-synthetic-key-concatenation-link-table-qlikview/

Why You sometimes should Load a Master Table several times