Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

michaelmedaflor
New Contributor

add dates in between and rearrange the format from columns to rows

Please if you can help me add dates in between and rearrange the format from columns to rows

    Mytable

VacStartDateVacEndDateEmp
28/01/201802/02/2018140115
23/01/201824/01/2018140009

  Desired results.

DateEmp
28/01/2018140115
29/01/2019140115
30/01/2020140115
30/01/2021140115
31/01/2022140115
01/02/2023140115
02/02/2024140115
23/01/2018140009
24/01/2018140009

Regards,

Mike

1 Reply
rupamjyotidas
Valued Contributor

Re: add dates in between and rearrange the format from columns to rows

Did you try building a calendar using interval match of VacStartDate and VacEndDate. You will find many examples for the same in the community.

Community Browser