3 Replies Latest reply: Jan 11, 2016 9:56 AM by Sunny Talwar RSS

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

    Laxmaiah Chowdary

      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.