0 Replies Latest reply: Jul 25, 2017 11:53 AM by Rasmus Nielsen RSS

    How to format custom week/year field in NPrinting?

    Rasmus Nielsen

      I have the following field in my data load script:

      Dual(Replace(WeekName(fillingDate), '/', '-'), weekstart(fillingDate)) AS [fillingYearWeek];

      This helps me display dates as week + year: 2017-01 which is week 1 in 2017.

      When I add it as a dimension to a qlik sense table, it works perfect. The purpose is to have a row for each week of the year.

      I am creating a NPrinting Pixel perfect report and are adding the table as a level in my report. When the table is displayed in my PDF report, it is just a number. I have tried putting Text() around my field in the Qlik sense table dimension, but this does not work in Nprinting.

      How can I format this column in NPrinting to display the week/year as it does in my Qlik sense app?