topic Re: need help in QlikView

need help

Thu, 18 Jun 2015 13:18:35 GMT

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

Re: need help

Thu, 18 Jun 2015 13:25:15 GMT

can u tell me what is your start date..

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

Re: need help

Anonymous — Thu, 18 Jun 2015 13:28:26 GMT

you have to use set analysis

sum({<datefield=>}sales)

Re: need help

sunny_talwar — Thu, 18 Jun 2015 13:30:16 GMT

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