Discussion Board for collaboration related to QlikView App Development.
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
Load [User ID],
[Create Date] as DateField,
'Create Date' as Flag
From <Data Source>;
[Login Date] as DateField,
'Login Date' as Flag
Load [Transaction Date] as DateField,
'Transaction Date' as Flag,
From <Data Source1>;
Load AutoNumber([User ID] & '|' & DateField) as %Key Resident UserTable;
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;
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?
Sure, Usually when i start surf "Use of Link Table". I got link and same from Deepak. You may liked it and better understand
Why You sometimes should Load a Master Table several times