Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
marco_puccetti
Partner - Creator
Partner - Creator

Qliks

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

8 Replies
vikasmahajan

you can use cross table for the same refer demo

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution.
If you want to go quickly, go alone. If you want to go far, go together.
kaushiknsolanki

Hi,

Try Crosstable function.

Crosstable ‒ Qlik Sense

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Chanty4u
MVP
MVP

use cross table

crosstable (Column, Value)

marco_puccetti
Partner - Creator
Partner - Creator
Author

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
marco_puccetti
Partner - Creator
Partner - Creator
Author

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

Not applicable

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
Partner - Creator
Partner - Creator
Author

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

Thanks

Marco