topic Re: comparing two columns in set analysis in QlikView

comparing two columns in set analysis

ali_hijazi — Sat, 19 May 2012 13:05:47 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

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

Re: comparing two columns in set analysis

jagannalla — Sat, 19 May 2012 13:23:38 GMT

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))"}

comparing two columns in set analysis

ali_hijazi — Sat, 19 May 2012 14:20:05 GMT

How Min(OpenDate)?

I need to compare with open date of each business unit

comparing two columns in set analysis

ali_hijazi — Sat, 19 May 2012 14:55:36 GMT

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

Re: comparing two columns in set analysis

jagannalla — Sat, 19 May 2012 15:00:08 GMT

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.

comparing two columns in set analysis

ali_hijazi — Sat, 19 May 2012 15:12:57 GMT

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