Discussion board where members can get started with Qlik Sense.
Anyone help me to create a canonical date for the below data in "Qlik Sense".
In below data, I need canonical date for, date_created, date_completed and date_signed.
LIB CONNECT TO 'MyDB';
SQL SELECT `invitation_id`,
SQL SELECT `course_completion_id`,
Have you read this: Canonical Date
Yes, i tried many things. but it's not getting. so i posted here.
please help me write code for that.
all the dates are in separate tables. We can create a duplicate field in each table and rename with same field name.
Ex. date_created as Date
date_completed as Date
date_signed. as Date.
So if we will make selection to Date Field, data for each table will get selected.
I am not very sure if this is you are looking for.