Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Check this
Dimensions
OrderID
OrderName
OrderDate
OrderItem
Expression
=Only({<OrderDate = {'>=05/11/2012<=03/01/2015'}>}OrderAmount)
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
Try the attached sample:
Expression:
=Only({<OrderDate = {"$(='>=' & vFrom & '<=' & vTo)"}>}OrderAmount)
Where vTo and vFrom are driver by the two drop down input boxes on top right.