Hi all,
I am desperate for a good book on set analysis for QLIK. I am not just looking for beginner, I need something that will help me develop advanced measures like a dynamic average cost (i.e. a measure that will give average cost over the last x days, or x months, or x years, depending on what the analyst drops into the chart. )
for example, a QLIK consultant left behind a measure that looks like this>>
Num(
(Sum({$ <
[Status Year]=
,[Status Day]={"<=$(=Date($(vMaxSelectedOPDate)))"}
,[Status Month]=
,[Status MonthYear]={"$(=Date($(vMaxSelectedOPMth),'MMM-YYYY'))"}
,[Status Quarter]=
,[Status QuarterYear]=
,[Status Weekday Name]=
,[Status WeekNum]=
,[OrgNode Test Flag 1]=$(vDefaultOrgNodeTestFlag1)
>}
[Total Count W/Test])
/
Sum({$ <
[Status Year]=
,[Status Day]={"<=$(=Date($(vPriorSelectedOPDate)))"}
,[Status Month]=
,[Status MonthYear]={"$(=Date($(vPriorSelectedOPYrMth),'MMM-YYYY'))"}
,[Status Quarter]=
,[Status QuarterYear]=
,[Status Weekday Name]=
,[Status WeekNum]=
,[OrgNode Test Flag 1]=$(vDefaultOrgNodeTestFlag1)
>}
[Total Count W/Test])
)
-1
,'0.0%')
I want something that can explain what is happening with all these "[field name] = " stuff and why it is blank after the "=" and how this whole thing works. Any recommendations?
