Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
agaetisproject
Contributor III
Contributor III

Pivot data in Export

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!

0 Replies