7 Replies Latest reply: Dec 19, 2017 6:08 AM by Or Shoham RSS

    QlikView November 2017 Export to Excel

    Matias Undurraga

      Hello,

       

      Just updated to QlikView Nomber 2017 release. I try to export dual fields into excel now they import as number and not text.

       

      Do we have any setting to revert to export dual fields as text and not numbers?

       

      Just as background we set some dual fields like Market Name so that we can sort them on the value instead of text.

       

      I know the Easter egg function ExcelExportMixedAsText, It should export mixed values as text, this has now changed...

       

       

      Best,

      Matias Undurraga

        • Re: QlikView November 2017 Export to Excel
          Steve Dark

          Hi Matias,

           

          I remember when the same bug slipped into QlikView some years back, for a service release or two.

           

          Hopefully it will be resolved soon.

           

          The thing that makes it complicated, I guess, is that Date fields are duals, and these should go into Excel as numbers, but every other type of dual you probably want the text to go across.  I'm not sure how easy it will be for the developers to tell them apart.  As you say though, it was working previously.

           

          You may want to raise a ticket on this one through Qoncierge and point them to this thread, so it can get logged as an issue.

           

          Cheers,
          Steve

          • Re: QlikView November 2017 Export to Excel
            Nicola Papapicco

            Same issue here, last week I upgraded a customer installation and today they discovered the problem. I have raised a ticket of course. Waiting for a feedback from them.

             

            Nicola

            • Re: QlikView November 2017 Export to Excel
              Igor Stepanov

              Before fix this problem, I use Easter egg function SendToExcelLegacyFormat=1 for export to xls instead of xlsx

              • Re: QlikView November 2017 Export to Excel
                Or Shoham

                Following up, SR1 has been released and the issue appears to have been partially handled.

                • Dates explicitly formatted as dates in script export correctly.
                • QlikView-generated dates (e.g. today() ) export correctly.
                • Dates read directly from a database (e.g. Oracle's SYSDATE) do not export correctly natively, but will export correctly if explicitly formatted as a date in a chart's Number settings.
                • Explicit Dual() dates (e.g. Dual(Today(), Today()) will not export correctly natively, but will export correctly if explicitly formatted as a date in a chart's Number settings.

                 

                So, in summary - if you format all your dates explicitly anyway, you're good to go. Otherwise, you may still encounter issues. I've reported the above to Qlik, so hopefully they'll finish the job on these exports in the next patch.