Qliks

[marco_puccetti]

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   |

Thanks

Marco

[vikasmahajan]

you can use cross table for the same refer demo

Vikas

[kaushiknsolanki]

Hi,

Try Crosstable function.

Crosstable ‒ Qlik Sense

Regards,

Kaushik Solanki

[Chanty4u]

use cross table

crosstable (Column, Value)

[marco_puccetti]

And how can i use it within a Pivot table?

Thanks

Marco

[kaushiknsolanki]

Hi,

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.

Regards,

Kaushik Solanki

[marco_puccetti]

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?

Thanks

Marco

[#8]

There's probably a better, less messy way without tmp fields but here you go 1 solution:

Table:
load * inline [
'Column A','Column B','Column C'
'VAL A','VAL B','VAL C'
];


CrossTableData:
Crosstable ("Column 1","Column 2")
Load '' as tmp,"Column A","Column B","Column C" Resident Table;
drop field tmp;
drop table Table;

[marco_puccetti]

I think to Which is the best manner to use it in a pivot table?

Thanks

Marco