Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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 & like it.
If you want to go quickly, go alone. If you want to go far, go together.
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Try Crosstable function.

Crosstable ‒ Qlik Sense

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
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
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
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