Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
These expressions are using set analysis to modify the QlikView data selections.
Hey Bjh,
Check these out. They might be useful.
http://community.qlik.com/docs/DOC-4951
http://community.qlik.com/thread/64623
Thanks
AJ
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.