Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
navaskhan
Contributor III
Contributor III

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
Anil_Babu_Samineni

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;

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
luismadriz
Specialist
Specialist

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

Anil_Babu_Samineni

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)