7 Replies Latest reply: Apr 20, 2016 2:18 PM by Avinash R RSS

    Pixel perfect - how can I organize my levels?

      Hello,

       

      I have a simple application with two tables like this:

       

      Sales table:

      DateSales OfficeCategoryACategoryBCategoryCSales
      19/04/2016X1001000
      19/04/2016Y0101500
      20/04/2016X1002000
      20/04/2016Y0102500
      20/04/2016Z010500

       

      Calendar:

      DateYesterdayCurrentMonth
      19/04/201611
      20/04/201601

       

      In my Qlikview application, I have a table called SalesReport set up like this:

       

      Sales OfficeSum Sales
      X3000
      Y4000
      Z500

       

      I'm not very comfortable with levels in NPrinting, but I'm trying to set up a Pixel Perfect report that would look like this (sorry, the formatting here is not very good looking:

       

      Yesterday's performance:

      CategoryA

      SalesOfficeSum Sales
      X1000
      TotalCatA1000

      Category B

      SalesOfficeSum Sales
      Y1500
      Total Cat B1500

       

      Total Yesterday2500

       

      Current Month:

      Category A

      Sales OfficeSum Sales
      X3000
      Total CatA3000

      Category B

      Sales OfficeSum Sales
      Y4000
      Z500
      Total CatB4500

       

      Total Current Month7500

       

      In my report, I imported my table SalesReport and I tried adding my levels like this:

      1. Yesterday (with filter Yesterday = 1)
        1. CategoryA (with filter CategoryA = 1)
        2. CategoryB (with filter CategoryB = 1)
      2. CurrentMonth (with filter CurrentMonth = 1)
        1. CategoryA (with filter CategoryA = 1)
        2. CategoryB (with filter CategoryB = 1)

       

      Then, I tried to insert my table SalesReport in each of the level, but the results are either blank or I have an error saying "the specified cast is unvalid", and I couldn't find anything on this error.

       

      Did I understand levels correctly? I tried doing the same thing in an Excel report and it seemed to work (except the filters and the nested levels, of course)...