Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Tanisha_36
Contributor II
Contributor II

link table for sales and budget dates

in qlik sense i am creating a link table to generate master calender in that link table i am having order date as dates ,sales ord id,flag as order concatenated with quota date as dates, emp_id,flag as quota but now sales is changing wrt year but quota is not changing

and if i do like in that link table i am having order date as dates ,emp id,flag as order concatenated with quota date as dates, emp_id,flag as quota

then quota is right but sales is wrong

what should I do

Labels (6)
1 Reply
brunobertels
Master
Master

hi 

may be this link will help you 

https://community.qlik.com/t5/Design/Canonical-Date/ba-p/1463578 

 

Regards