Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a simple application with two tables like this:
Sales table:
Date | Sales Office | CategoryA | CategoryB | CategoryC | Sales |
---|---|---|---|---|---|
19/04/2016 | X | 1 | 0 | 0 | 1000 |
19/04/2016 | Y | 0 | 1 | 0 | 1500 |
20/04/2016 | X | 1 | 0 | 0 | 2000 |
20/04/2016 | Y | 0 | 1 | 0 | 2500 |
20/04/2016 | Z | 0 | 1 | 0 | 500 |
Calendar:
Date | Yesterday | CurrentMonth |
---|---|---|
19/04/2016 | 1 | 1 |
20/04/2016 | 0 | 1 |
In my Qlikview application, I have a table called SalesReport set up like this:
Sales Office | Sum Sales |
---|---|
X | 3000 |
Y | 4000 |
Z | 500 |
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
SalesOffice | Sum Sales |
---|---|
X | 1000 |
TotalCatA | 1000 |
---|
Category B
SalesOffice | Sum Sales |
---|---|
Y | 1500 |
Total Cat B | 1500 |
---|
Total Yesterday | 2500 |
---|
Current Month:
Category A
Sales Office | Sum Sales |
---|---|
X | 3000 |
Total CatA | 3000 |
---|
Category B
Sales Office | Sum Sales |
---|---|
Y | 4000 |
Z | 500 |
Total CatB | 4500 |
---|
Total Current Month | 7500 |
---|
In my report, I imported my table SalesReport and I tried adding my levels like this:
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)...
did you checked this
How to Create Excel Reports with Nested Levels and Subtotals
Yes, I tried following this tutorial. I couldn't understand how I can sum my sales through categories A, B, and C, though.
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
In a Pixel perfect report?
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
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:
Date | Sales Office | Category | Sales |
---|---|---|---|
19/04/2016 | X | A | 1000 |
19/04/2016 | Y | B | 1500 |
20/04/2016 | X | A | 2000 |
20/04/2016 | Y | B | 2500 |
20/04/2016 | Z | B | 500 |
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.
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