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 |
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;