0 Replies Latest reply: Jun 5, 2012 4:42 AM by Ashish Michael RSS

    Festival Sales Analysis

    Ashish Michael

      I have a three tables and want to display the range sum of sales from specific festival. For example two days sales sum from diwali festival. Sample Application is attached Pls Help !!!!!!!!!!!!!!!!!!

       

       

      Festival_Table:

      FDate, Festival;

       

      Nokia Sales:

      LOAD Date,

          "BB_Price",

          BillNo,

          Category,

          Coll,

          Discount,

          "Discount_Per",

          DP,

          FM,

          "FM_Per",

          Model_No,

          Qty,

          SCode

          From D:\QLick View Files\QVD\NOKIA_SALES.qvd(qvd);

       

      Calender:

       

      TempCalendar:

      Set Soft_Date=Num('01/01/2002');

      Set Curr_Date=Today();

      LOAD

      $(Soft_Date)+IterNo()-1 AS Num,

      Date($(Soft_Date)+IterNo()-1) AS Date

      AUTOGENERATE 1 WHILE $(Soft_Date)+IterNo()-1 <= $(Curr_Date);

       

      TempCalendar1:

      Load Date,

           Year(Date) As Year,

           Month(Date) As Month,

           Day(Date) As Day,

           Month(Date)&'-'&Day(Date) As Day_Month

           Resident TempCalendar;

       

           Drop table TempCalendar;