Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
what happens if you make a pivot table instead a straight table?
ahh, sorry. i thought its qlikview related. my fault 🙂
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