Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Display the whole period on X-axis when values from two calendars are selected


I have two calendars left for start date and right to end date.

I have also a Cyclic group for X-axis , which is date (day, week etc.). 
My difficulties are:

1. How to display the whole period between the values selected in the two calendars ? Currently when I pick period between 2016 and 2021 (check the sample) I receive always days from 1 to 31; weeks from 1 to 53 and months from January to December no matter that 5 years are selected.

2. How to avoid the appearance of a date like numbers in the calendar when i change the selections? Initially I have date and when I start to select these dates are switched to numbers.

Please, check the sample report.

Best Regards,

Labels (1)
1 Reply

But why you are not using "Full_Date" as Dimension instead of Full_Date_Year which in facts is Year?

To help community find solutions, please don't forget to mark as correct.