Qlik Community

Qlik Sense App Development

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

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
marco_puccetti
Not applicable

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
Not applicable

Re: Qliks

you can use cross table for the same refer demo

Vikas

kaushik_solanki
Not applicable

Re: Qliks

Hi,

Try Crosstable function.

Crosstable ‒ Qlik Sense

Regards,

Kaushik Solanki

Chanty4u
Not applicable

Re: Qliks

use cross table

crosstable (Column, Value)

marco_puccetti
Not applicable

Re: Qliks

And how can i use it within a Pivot table?

Thanks

Marco

kaushik_solanki
Not applicable

Re: Qliks

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
Not applicable

Re: Qliks

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

Re: Qliks

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
Not applicable

Re: Qliks

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

Thanks

Marco