0 Replies Latest reply: Nov 21, 2017 4:15 AM by Mikael Strahlem RSS

    Is this possible? Calc Dimension / Expressions

    Mikael Strahlem

      Good morning Qlik community,

       

      I just wanted to reach out and see if this data layout would be possible in a pivot or straight table?

       

      qlikviewTable.png

       

      Only month, and full-year are available as raw-data.  A simplistic version of what I need is attached, but I can only get the first column (month) to function properly.  This version is not my full qlikview, due to sensitivity of data, I cannot post that one.  Nevertheless, I can provide the data model. 

       

      export.png

       

      The biggest issue I am running into is that since a lot of my KPI's are %-based, they need to be computed on the fly to avoid avg(%) which isn't correct, since it is not a weighted average.  For instance, my sixth KPI is this expression:

       

      SUM(KPI_DWHOPI_BIZ_HOURS_ADJ_DEALS_REVIEWED) /
      (sum(KPI_DWHOPI_DEALS_APPROVED_W_COND) + sum(KPI_DWHOPI_DEALS_APPROVED_WO_COND) + sum(KPI_DWHOPI_DEALS_REJECTED))
      
      

       

      Also, I should state, a requirement is that YTD is based on the month's selection; so you could for instance click Feb, and it does a YTD of Jan-Feb; not YTD based on the current date (my data is monthly based, not daily). 

       

       

      Thank you for your assistance,

       

      -Mikael