Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a way to define pages - for example in excel templates - by a calculated dimension?
In Excel, you can use all the Excel pagination features (define page breaks, headers...).
You can also use the Levels feature to create a page for every value of a dimension.
You can use the Page feature to create a worksheet for every value of a dimension.
If you need advanced pagination features then I suggest you build a report in Word or Pixel Perfect formats as there are more options (like table of contents, calculated sums for each page...)
There are lots of tutorials about template authoring here:
https://community.qlik.com/docs/DOC-14575
QlikView NPrinting 16 Tutorials - PixelPerfect Reports
QlikView NPrinting 16 Tutorials - Word Reports
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.
Hi Aran - I think the problem described here is that Page or Level functionality will not work on "Calculated Dimension" from Chart; Is this what you are asking Saska?
I remember trying to achieve this in order to build top 10 and bottom ten table in Pixel Perfect - so I build calculated dimension which handled all the logic, but when i tried to use it as a level in Pixel Perfect it was returning an error. See this comment for reference:
Pixel Perfect Table - Sales by top X
regards
Lech
Calculated dimensions are not present in the data model as a real field, therefore not usable from NPrinting directly.
But you could use the entire table that contains that calculated dimension as level or page.
Please consider that there are some limitations on doing this, as explained here:
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.
that is very useful!
thanks Andrea!
Thank you all!
Unfortunately I can not use this in a way I intended as my plan was to loop through a calculated dimension and place data from another object inside that loop. As stated in the link provided by Andrea:
"Tables that have calculated dimensions or null values can be used as levels, but you cannot put any objects or levels inside them."
Edit 4.8.2017: Tested this -> it seems to be possible but the results are not logical. When you put an object inside a calculated dimension level, same data seems to be output in every level value. That is the calculated dimension does not limit the data in another object.
i have to re-test it on example. It actualy think it will work - will keep you posted!
cheers
Lech
Your trying the levels over the same chart you have the calculated dimension or your trying to include the other objects under that ?? if that is the case it won't work because the calculated dimension does not have the direct relation with the other
Maybe you could to move the calculated dimension into a new field calculated by the loading script and use this in the Page node.