Set analysis

[Kushal_Chawda]

I want some logic .

1) If I select any year, I want sum of sales upto that year..example If I select 2007 I should get sum from 2003 to 2007 not only 2007

2) Same logic for month..If I select Mar…I should get sum from Jan to Mar.

3) Same  logic for Quarter….If I select Q2…. I shouldget sum of Q1 and Q2.

4) Same logic for Week…If I select week 5…I should get sum ofweek 1 to 5.

5) Same logic for day…..

[Miguel_Angel_Baeyens]

Hi,

I uploaded some time ago a QlikView to do that using variables and a master calendar. Download it here.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica