Looking for a transpose option in table (metrics into rows)

[Anonymous]

Hi ,

I have a table where i'm displaying only measures and no dimensions in QlikSense .

QlikSense table currently displays it in this format (multiple columns)

But my requirement is to show it in a transposed manner (Columns into rows) :

Need help in achieving this.

[Mark_Little]

Hi Kevin,

Not sure of a way front end out of the box, Might be possible with an extension have a look at the QlikBranch.

One way you could achieve it is within the script with an aggregated table, but could be a more work than it is worth.

Mark

[andrey_krylov]

Hi Kevin. I'm not a QS user but in QV it may be done with so-called dummy dimension.

DummyTable:

Load * inline[

$DummyDim

Count laptops

Count desctops

Count emploees

];

Add this dimension to the chart and add the expression

=Pick(Match($DummyDim,'Count laptops', 'Count desctops', 'Count emploees'),

Count(Laptops), Count(Dsctops), Count(Emploees))

You can implement this through a valuelist but I do not use this way since there can be difficulties with aggregation.

[brunobertels]

Hi Kevin

As Andrey said Pick(Match function will do the job

Another maner is to use valuelist function

Mesure Name

valuelist('

laptops','desctops','emploees')

And as mesure :

If(valuelist('laptops','desktops','employees')='laptops',count(laptops),

If(valuelist('laptops','desktops','employees')='desktops',count(desktops),

If(valuelist('laptops','desktops','employees')='employees',count(employees)))

[nsetty]

Try CrossTable