pivotTable() function

[Anonymous]

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?

[sunny_talwar]

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

[swuehl]

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?

[Anonymous]

Yes I need to put the function in my script.

can I use the function crossTable() ?

[swuehl · Accepted solution]

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.