0 Replies Latest reply: Jul 17, 2017 4:56 PM by Jeff Robertz RSS

    Pivot data in Export

    Jeff Robertz

      Hi all,

       

      More and more I am using Qliksense to collect data, process them and create outputs tables that my client then inject in their systems.

      Here is a use case to feed a FICO table I am struggling with.

      My goal is to export a 'pivot' table looking like this:

       

      Field1Field2Field3Field4Value1Value 2Value3Value4
      A2USIC10101010
      A2GBIC888
      A2SPIC1010

       

      Instead of this:

       

       

      Field1Field2Field3Field4Value
      A2USIC10
      A2USIC10
      A2USIC10
      A2USIC10
      A2GBIC8
      A2GBIC8
      A2GBIC8
      A2SPIC10
      A2SPIC

      10

      Can anyone help me pivoting those and generating a text file straight from the script?

       

      Overall, I would love to know if QlikSense offers apis to produce custom reports from its data as the use case to create fancy export to feed interfacing systems is something I see more an more.

       

      Thanks for your help!