Date Expressions

[#1]

I'm trying to understand exactly what these types of expressions mean...

avg({$<[Project Gate Name]={"Design Objective Review - Go to Phase 2"}>} [Project Milestone Date] - [Project Stage Duration])

avg({$<[Project Gate Name]={"Design Objective Review - Go to Phase 2"}>} [Project Stage Duration])

...can anyone point me to a document that would help me?

Thanks!

bjh

[Colin-Albert]

These expressions are using set analysis to modify the QlikView data selections.

Set Analysis Wizard for QlikView | qlikblog.at

[#3]

Hey Bjh,

Check these out. They might be useful.

http://community.qlik.com/docs/DOC-4951

http://community.qlik.com/thread/64623

Thanks

AJ

[MayilVahanan]

Hi

avg({$<[Project Gate Name]={"Design Objective Review - Go to Phase 2"}>} [Project Stage Duration])

It calculates the average of [Project Stage Duration] and for the field [Project Gate Name] is "Design Objective Review - Go to Phase 2".

i.e. Even though you select the other value in Project Gate Name, the expression does not considered that. It calculates only  "Design Objective Review - Go to Phase 2" value for that field.

For ex:

Sum(sales) - its calculate all the sales and reflect according to selection in filters.

Sum({1}sales) - its exclude all the selection

Sum({<Year={2014}>}sales) - its calculates the sales only for 2014 year. if you select 2013, there is no reflect in that. But the expression reflects other than year selection - like quarter, month, etc.