6 Replies Latest reply: Apr 9, 2017 2:43 PM by Oleg Troyansky RSS

    Good book on set analysis??

    Christopher Obert

      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?