topic Re: Date Expressions in QlikView

Date Expressions

Wed, 08 Jan 2014 21:00:18 GMT

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

Re: Date Expressions

Colin-Albert — Wed, 08 Jan 2014 21:10:52 GMT

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

Set Analysis Wizard for QlikView | qlikblog.at

Re: Date Expressions

Wed, 08 Jan 2014 21:15:22 GMT

Hey Bjh,

Check these out. They might be useful.

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

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

Thanks

Re: Date Expressions

MayilVahanan — Wed, 08 Jan 2014 22:20:08 GMT

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.