Set analysis

Kushal_Chawda — Sun, 11 Sep 2011 08:30:50 GMT

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 — Sun, 11 Sep 2011 10:47:53 GMT

Hi,

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

Hope that helps.

BI Consultant

topic Set analysis in QlikView