Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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)...

7 Replies
Not applicable
Author

Yes, I tried following this tutorial. I couldn't understand how I can sum my sales through categories A, B, and C, though.    

avinashelite

If you have build the chart in Qlikview with the total as sum enabled , then it will automatically sum up the values rite ...you no need to do anything

Not applicable
Author

In a Pixel perfect report?

avinashelite

Yes , levels works just like the selection in Qlikview , so in Qlikview if you select the Categories A , B and C ..whats the value reflecting in QV same will be copied to NPrinting ..NPrinting doesn't make any selection it just makes selection and copy and paste the objects ...

Hope this helps you to understand the levels concept

Not applicable
Author

Ok, after a few tries, I think I have a better understanding of levels. Thanks. I'm stuck with filters, though.

I have changed my sales table a bit to look like this:

DateSales OfficeCategorySales
19/04/2016XA1000
19/04/2016YB1500
20/04/2016XA2000
20/04/2016YB2500
20/04/2016ZB500

And my levels now look this:

Yesterday

     Category

          SalesReport table

CurrentMonth

     Category

          SalesReport table

However, I would like to filter my Yesterday flag to 1.

I went to this level, click on the FilterString field, click on "and" and added 1 to the values. When I preview the result, everything is blank. If I remove this filterstring, then I can see everything.

Is there anything about level filters? I couldn't find a thread about this.

avinashelite

once you import the object in report editor, right click on the object > properties > you will the option to add the filter ....before this you need create the filter using the filters option in the main menu

hope this helps you