Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
joeybird
Creator III
Creator III

group by date SQL Qlik Sense

Hiya

I have a table loaded in via a SQL server,

however, the filter pain for Order_Date

is showing multiple order date instances

e.g

04/04/2015

04/04/2015

04/04/2015

04/04/2015

06/04/2015

06/04/2015

06/04/2015

07/04/2015

I wish it to show

04/04/2015

06/04/2015

07/04/2015

is there a way of grouping by the date??

I have a calendar, and the based on the order date

I have tried

day(Order Date) in expression

and the same happens

please help

10 Replies
joeybird
Creator III
Creator III
Author

Hiya

worked a treat thank you xx

Kind Regards

Joeybird