topic Set Analysis using other fields in QlikView

Set Analysis using other fields

Wed, 23 Sep 2009 19:38:06 GMT

I am trying to calculate the impact of a new product launch. A new product is only new for so long so need to use set analysis to restrict the date range.

Alongside each sales line I have the launch date for the product.

so in theory the set analysis should look something like this

sum(

{

[ShipDate]={">=LaunchDate <([LaunchDate]+35)"}

}

Quantity) however if I use this I get no results if I discreetly enter the dates I get the correct answer as below

sum(

{

[ShipDate]={">=LaunchDate <([LaunchDate]+35)"}

}

Quantity)

I have attached an example - am I just doing something wrong with the syntax for using the launchdate?

Thanks

Matt

Set Analysis using other fields

Wed, 23 Sep 2009 19:41:48 GMT

Hi Matt,

where are your example???

Rainer

Set Analysis using other fields

Wed, 23 Sep 2009 19:51:22 GMT

Sorry Attachment should now be there

Matt

Set Analysis using other fields

markmccoid — Wed, 23 Sep 2009 20:34:56 GMT

Hi, You need to use $ expansion on the dates:


sum({<[ShipDate]={">=$(=LaunchDate) <$(=date(([LaunchDate]+35)))"}>}Quantity)