Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Partner
Partner

Transpose a table without a Dimension

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 ValueLow ValueTotal Cost
9530150

 

Desired Output:

High Value95
Low Value30
Total Cost150
5 Replies
Frank_Hartmann
Honored Contributor II

Re: Transpose a table without a Dimension

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

 

1.gif

Partner
Partner

Re: Transpose a table without a Dimension

Im using Qlik Sense, if i convert to pivot , then im forced to use Dimension
Frank_Hartmann
Honored Contributor II

Re: Transpose a table without a Dimension

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

arulsettu
Honored Contributor III

Re: Transpose a table without a Dimension

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

Partner
Partner

Re: Transpose a table without a Dimension

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?