need help

[#1]

Hi I have few new product being added over a time in my table .

so suppose i have 4 products added in march and 5 more in may and 2 more in june

so if i select june in calendar i want all the product added before that day not only 2 records as qlikview would filter the records.

this field in need to include in gauge chart in which i am trying to find the average of sale by using Aggr() function by using dimension as product

Avg(Aggr(Sum(sales)/total,product))

but if i am clicking on june , its giving only for two products but i want for all 11 and if i choose may i want for all 9 prroducts and so on 

[#2]

can u tell me what is your start date..

means 2015,2014,2013...???

[Anonymous]

you have to use set analysis

sum({<datefield=>}sales)

[sunny_talwar]

I think for your requirement, you might require RangeSum function together with the aggregate function. But to give you a better response we will require to look at some sample data.

Best,

Sunny