Discussion board where members can learn more about Qlik Sense App Development and Usage.
Hello, is it possible to create tables with the column names as left row list as in the following sample?
This is the state of the art
| Column A | Column B | Column C |
| VAL A | VAL B | VAL C |
This is what i want to get
| Column A | VAL A |
| Column B | VAL B |
| Column C | VAL C |
Try Crosstable function.
The solution which are given by many here i.e of Crosstable can't be used in Pivot, It has to be done in Script.
In specific, i have different misures (set analysis formula) that need to be expressed in a single column by different rows, of a pivot table.
So what could be a possible solution to this?
There's probably a better, less messy way without tmp fields but here you go 1 solution:
load * inline [
'Column A','Column B','Column C'
'VAL A','VAL B','VAL C'
Crosstable ("Column 1","Column 2")
Load '' as tmp,"Column A","Column B","Column C" Resident Table;
drop field tmp;
drop table Table;