Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

pivotTable() function

Hi,

I want to ask you if there is a function called pivotTable() where i can use to pivot my table and make the columns into rows and vice versa. If not, what function can I use?

1 Solution

Accepted Solutions
MVP
MVP

Sure, you can use CROSSTABLE Load prefix.

The Crosstable Load

Though it's not the exact same as Transpose() filter, i.e. it won't pivot the complete input table.

Not sure what you are trying to achieve.

View solution in original post

4 Replies

There is a pivot table object in Qlik Sense, but I don't think there is a function like that....

MVP
MVP

Are you looking for a function in the script part?

Maybe a LOAD format specification filter may help you (this one is created using the QV script editor, I think it should also work with QS):

LOAD FieldA,

          FieldB,

          FieldC,

FROM

(ooxml, embedded labels, table is [Raw data], filters(

Transpose()

));

Or are you looking for something completely different?

Contributor
Contributor

Yes I need to put the function in my script.

can I use the function crossTable() ?

MVP
MVP

Sure, you can use CROSSTABLE Load prefix.

The Crosstable Load

Though it's not the exact same as Transpose() filter, i.e. it won't pivot the complete input table.

Not sure what you are trying to achieve.

View solution in original post