Skip to main content

New to Qlik Sense

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

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
kevdmello
Contributor
Contributor

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

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)

QS.PNG

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

Transpose.PNG

Need help in achieving this.

4 Replies
mark6505
Partner - Master
Partner - Master

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
Specialist
Specialist

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
Specialist III
Specialist III

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
Partner - Creator II
Partner - Creator II

Try CrossTable