Table Row to Columns

[Timerichhh]

Hey everybody,

I am kinda new to Qlik and I may need your expertise. I have a straight table and I want to show some generic information. I thought I could use a table for this. But I really have no clue how I can get the row to columns.

At the end I want something like this:
Baujahr: 1992
Buchwert (€): 21185000
Fläche: 9200
Letzte Sanierung: 2018
...

How can I achieve a visualisation like this?

[PrashantSangle]

Do you have any dimension?

use Pivot > add dimension > add all measures then change position of Values to left & drag dimension to top.

If you don't have dimension & always fixed number of rows then use KPI Object for each row.

[Daniel_Castella]

Hi @Timerichhh 

I'm not sure if I'm fully understanding your request. Why do you need a table to display the information you describe? I think it is easier to display it with a text object like in the image below:

In that object you can combine plain text with measures and display them as you need.

Let me know if it works for you or if further explanation is needed.

Kind Regards

Daniel

[marcus_sommer]

You may separate these information into two fields, for example like:

t: load *,
           subfield(myField, ':', 1) as Category,
           trim(subfield(myField, ':', 2)) as Value
  from mySource;

and then you could apply a pivot and using Category as horizontal dimension and an expression like:

sum(Value)

If there are not only numbers you could use only() or concat() to fetch the values.

[Chanty4u]

Try this 

Your calculated dimension 

ValueList(

    'Baujahr',

    'Buchwert (€)',

    'Fläche',

    'Letzte Sanierung'

)

Measure:

Pick(

    Match(ValueList(

        'Baujahr',

        'Buchwert (€)',

        'Fläche',

        'Letzte Sanierung'

    ),

    'Baujahr',

    'Buchwert (€)',

    'Fläche',

    'Letzte Sanierung'

    ),

    Max(Baujahr),

    Num(Max(Buchwert), '#,##0 €'),

    Max(Fläche),

    Max(LetzteSanierung)

)