Festival Sales Analysis

[qlik107]

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;