what's wrong in the set analysis

[ali_hijazi]

Hello

I got a qlikview document that has the following tables:

Daily Sales

Business Units

Calendar

The Calendar has a field called [Transaction Date] linked to the Daily Sales

and the Daily Sales has a field [BU Code] that links it to the table Business Units

Each business unit has an [Open Date] that determines when the businees unit was open

Now the user selects the Year 2012 and Week 14

in a chart I want to find the following:

The sales of each business unit that correspond to the transactions that have date ([Transaction Date]) at least one year after the opening date of the business unit

in the chart I have as Dimension the [BU Code] (code of the business unit

The expression is as follows:

sum

          (

                    {

                    <

                                        H_Flag={'Sales'},

  [Transaction Date] = {">= $(=num(AddMonths(([Open Date],12)))"}

  >

                      }

                    [Sales Amount USD]

          )

whenever the red line above is added then when I select a specific business unit I get the correct answer However when all business units are present the values are wrong

Please advise

[vgutkovsky · Accepted solution]

Ali, see my answer in this post, you have the same issue with your set analysis: http://community.qlik.com/message/219975#219975

Regards,

Vlad

[SunilChauhan]

sum

          (

                    {

                    <

                                        H_Flag={'Sales'},

  [Transaction Date] = {">= $(=Date(AddMonths([Open Date],12)))"}

  >

                      }

                    [Sales Amount USD]

          )

hope this helps