5 Replies Latest reply: Nov 2, 2017 7:58 AM by Ruggero Piccoli RSS

    NPrinting does not export values into Excel file from Qlik Sense Pivot Table

    Victor-Ioan Siboiu

      Hello,

       

      I am having a problem with an Excel report I want to make. This consists of a Pivot Table that should be exported from Qlik Sense Server (version 3.2 SR5) using NPrinting (version 17.5). The template format is .XLSX.
      The table is transferred as data (I need every value afterwards).


      The Pivot Table consists of 2 rows (Country and City), 3 columns (Client, KPI, Time Period) and the Values (Values being the measure and the rest dimensions). In Qlik Sense, the Values field has the formula:


      pick(match(KPI,'KPI1','KPI2','KPI3', 'KPI4', 'KPI5'),

      num(IF(sum(No)=0,0,sum(No)),'###,###'),

      num(IF(sum(No)=0,0,sum(No)),'###,###'),

      num(IF(SUM(No)=0,0,sum(No)/SUM(NoTotal)) ,'####.#%'),

      num(IF(SUM(No)=0,0,sum(No)/SUM(NoTotal)) ,'####.#%'),

      num(IF(SUM(No)=0,0,sum(No)/SUM(NoTotal)) ,'####.#%'),

      )

       

      There could be a problem if I have 2 different data format types in the same Pivot Table?
      This appears  with/without a filter for year 2017, month January. When I use the filter for month January 2017 the returned results are for the year 2017 and when I select only 2017 there isn't nothing relevant returned.

       

       

      Thank you!