comparing two columns in 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

I wrote the following expression yet it is giving me nothing!

sum

          (

                    {

                    <

                                        H_Flag={'Sales'},

  [H_Transaction Date] = {">= $(=AddYears([Open Date],1))"}//,

  >

                      }

                    [Sales Amount USD]

          )

Please advise

[jagannalla]

Hello,

Your set analysis is wrong. B'coz we need to compare with values in set analysis, but you are comparing with field data.

For example:

H_TransactionDate={">=$(=Min(OpenDate))"}

[ali_hijazi]

How Min(OpenDate)?

I need to compare with open date of each business unit

[ali_hijazi]

How to add one year to the minimum of the Open Date as you are suggesting?

[jagannalla]

Can you attach sample file and also explain the output what you want i.e. Show the data of chart in image or table view.

[ali_hijazi]

Check attached document

in the chart the Tezenis brand should have some value for sure less than the one it is shown since this shop was opened on 5/5/2011

We are actually calculating the Like for like sales in the first column