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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date range by single date field in database table

I have a database table which has 2 fields orderDate and orderAmount. Now I need to create date range as from-order-date and to-order-date in 2 separate list box by using orderDate field. And also need sum(orderAmount) when customer select from-order-date and to-order-date from those list boxes.

orderDate
orderAmount
1/1/20151000
14/2/20154500
31/3/2015200
30/4/2015800
14/6/20153500

Anyone please provide video or process step by step.

10 Replies
Not applicable
Author

I have QV personal edition. Can you give any video, so that I can understand this answer.