Festival Sales Analysis

qlik107 — Tue, 05 Jun 2012 08:42:47 GMT

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;

topic Festival Sales Analysis in QlikView

Festival Sales Analysis