what's wrong in the set analysis

ali_hijazi — Sun, 20 May 2012 20:17:20 GMT

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

Re: what's wrong in the set analysis

vgutkovsky — Mon, 21 May 2012 00:18:27 GMT

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

what's wrong in the set analysis

SunilChauhan — Mon, 21 May 2012 07:33:20 GMT

sum

(

{

H_Flag={'Sales'},

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

}

[Sales Amount USD]

)

hope this helps

topic Re: what's wrong in the set analysis in QlikView

what's wrong in the set analysis

Re: what's wrong in the set analysis

what's wrong in the set analysis