crosstable query

[capriconuser]

i have this data

col1     col2     values

abc     q1         345

abc     q2          124

abc     q3             46

i want this like this cross table

abc     q1    q2     q3

           345 124    46

how i do this ?

[jonathandienst]

Create a pivot table with col1 and col2 as dimensions and Sum(values) as an expression/measure. Then pivot the table - click the col2 header and drag the red position indicator to the top until it switches to horizontal.

[shiveshsingh]

May be this

[MarcoWedel]

a script solution would be:

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptPrefixes...

regards

Marco

[capriconuser]

i treid but this shows nothing and also did not show red position

[sasiparupudi1]

Please post a sample

[shiveshsingh]

It's blue in color