0 Replies Latest reply: Aug 9, 2012 5:18 PM by Nick White RSS

    Expressions on Multiple Axes?

      Dearly beloved QlikCommunity,

       

      I'm a QV rookie, currently building out my first ever report. I'm a bit stuck (in something of a Qlikpickle, if you will).

       

      I've pasted in an excel drawing to build what I'm envisioning.

       


      Yesterday
      Trailing 7 Days
      Trailing 28 Days
      Quarter To Date
      Year To Date

      #% of leads#% of leads#% of leads#% of leads#% of leads
      Total Leads 534,313100% 550,000100% 482,212




      Leads Attempted 480,88290% 495,00090% 433,991




      Leads Connected 336,61763% 346,50063%





      Leads Closed 168,30932% 173,250






      so on...









       

      I've written the expressions for the relevant metrics, displaying them along the Y-Axis of my report. This works great for the first column, but how does one create multi-column tables showing different time periods?

       

      I would think that writing expressions along the X and Y Axes would get me there, but can QV do that? Is there a different way to get there?

       

      I'd ideally like to have percentage sub-columns alongside the raw data for each time period (as shown). Can this be done in QV as well?