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:
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.
Thanks for your help!