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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
RickyLam
Contributor III
Contributor III

Date ranges in heatmap chart not sorted properly

Hi all,

The date range of my heatmap chart somehow does not sort properly:

RickyLam_0-1689603584183.png

The date range in the heatmap chart above is from an expression of the dimension "Date Period": 

Date(WeekStart([OrderDate]), 'DD/MM/YY') & ' - ' & Date(WeekEnd([OrderDate]), 'DD/MM/YY')

I tried to wrap around the expression above by DUAL function like this:

Dual(Date(WeekStart([OrderDate]), 'DD/MM/YY') & ' - ' & Date(WeekEnd([OrderDate]), 'DD/MM/YY'), WeekStart([OrderDate]))

It does sort correctly; but the date ranges of the heatmap chart would become date serial number. Apparently the numeric value of the Dual function is displayed instead of the text value:

RickyLam_1-1689603918559.png

How can I display the date range text while internally using the WeekStart([OrderDate]) for sorting purpose? Please advise. 

 

 

 

Labels (3)
0 Replies