Transpose a table without a Dimension

[Nive]

Hello Guys,

Need a help in converting rows to columns in a straight table without using Dimensions.

Consider i have 3 measure values in Straight table:

High Value	Low Value	Total Cost
95	30	150

Desired Output:

High Value	95
Low Value	30
Total Cost	150

[Frank_Hartmann]

what happens if you make a pivot table instead a straight table?

[Nive]

Im using Qlik Sense, if i convert to pivot , then im forced to use Dimension

[Frank_Hartmann]

ahh, sorry. i thought its qlikview related. my fault 🙂

[arulsettu]

Maybe like this

CrossTable (Header,data,1)
load * Inline [
id,High_Value, Low_Value, Total_Cost
1,95, 30, 150
]

I am using id as dummy dimension to convert rows into column

[Nive]

Thanks Arulsettu..
The problem is i have more than 6 measure values to be computed in a table which requires complex expressions (using set analysis) and aggregations of different data sets.
can this be solved in UI itself?