Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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