topic Re: AVG Date in Set Analysis in QlikView

AVG Date in Set Analysis

Wed, 17 Oct 2012 09:52:35 GMT

Hi everyone,

I have a table with products and every product can have more shipping dates. Like this:

PoductID ShippingDate

1234 12.10.2012

1234 13.09.2012

1234 15.08.2012

4567 01.01.2012

4567 22.04.2012

4567 05.09.2012

I need to show now all products in a chart they where shipped in a certain time. for example 04.09.2012 - 16.10.2012. but the avg date should be in this daterange. so 1234 needs to be shown cause the avg(date) is in the daterange and 4567 shouldnt be shown but is because of the date 05.09.2012, cause right now my set analysis look like this

only({<ShippingDate = {'...'}>}ProductID)

i tried already:

only({<avg(ShippingDate) = {'...'}>}ProductID)

but this is not working

can i use avg() like this?? or does anyone know a workaround???

i appriciate any kind of help you guys can give me.

regards,

Re: AVG Date in Set Analysis

Jason_Michaelides — Wed, 17 Oct 2012 10:21:27 GMT

Please describe the chart you want to see. Dimension and expression?

Re: AVG Date in Set Analysis

Wed, 17 Oct 2012 10:29:12 GMT

I want to see the productID as dimension and as expression i want my profit!! maybe i have to explain the problem a lil more specific!!

I have a slidecontrol where I can choose how many week my product can be old (1-10). the slidecontrol is base on 2 variables. so when i choose 5 on the slide control I want to see all products with the average age of 5 weeks. (age is based on the avg shipping date but to explain all that in detail will get to complicated) so what i actually need is an dynamic dimension in a pivot table.

regards,

Re: AVG Date in Set Analysis

Jason_Michaelides — Wed, 17 Oct 2012 13:05:51 GMT

What version of QV arte you using?