Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to find order details in between dates with single order date column?

Hi QlikMates,

I have a strange task to implement which is about getting order details in between From date and To date using a single order date column.

My table is as follows:

OrderDetails:

LOAD * INLINE [

    OrderID, OrderName, OrderDate, OrderAmount, OrderItem

    101, Ram, 06/10/2010, 1000, Pen

    183, Krish, 07/01/2014, 2000, Book

    192, Kishore, 05/11/2012, 3000, Box

    203, Venky, 12/05/2015, 3500, Ink

    243, Koti, 03/01/2015, 4000, Phone

    301, Hari, 08/10/2014, 4500, Mobile

    305, Ravi, 09/10/2013, 5000, Laptop

    333, Sonu, 12/10/2012, 6000, Notepad

];

Now the requirement is to show order details in charts/tables between dates for e.g 05/11/2012 and 03/01/2015 with user selections on OrderDate listbox .

I have tried it on straight table but it shows details only for those dates not the entire details in between the dates.

Could somebody please help me here.

3 Replies
sunny_talwar

Check this

Capture.PNG

Dimensions

OrderID

OrderName

OrderDate

OrderItem

Expression

=Only({<OrderDate = {'>=05/11/2012<=03/01/2015'}>}OrderAmount)

Not applicable
Author

Thanks a lot Sunny.

But the order details have to be shown dynamically depending upon user selections. Like if a user randomly selects 2 dates in List box, the order details table should give the orders in between the dates.

Can you please help me in implementing this.

Thanks

sunny_talwar

Try the attached sample:

Capture.PNG

Expression:

=Only({<OrderDate = {"$(='>=' & vFrom & '<=' & vTo)"}>}OrderAmount)

Where vTo and vFrom are driver by the two drop down input boxes on top right.