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:
Field1
Field2
Field3
Field4
Value1
Value 2
Value3
Value4
A
2
US
IC
10
10
10
10
A
2
GB
IC
8
8
8
A
2
SP
IC
10
10
Instead of this:
Field1
Field2
Field3
Field4
Value
A
2
US
IC
10
A
2
US
IC
10
A
2
US
IC
10
A
2
US
IC
10
A
2
GB
IC
8
A
2
GB
IC
8
A
2
GB
IC
8
A
2
SP
IC
10
A
2
SP
IC
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.
