Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
<body><p>Hello,</p> <p> </p> <p>Is it possible to create a table like this in qlikview:</p> <p> </p> <p> ColumnName1 ColumnName2</p> <p>RowName1 Value Value</p> <p>RowName2 Value Value</p> <p>RowName3 Value Value</p> <p>RowName4 Value Value</p> <p> </p> <p>I have the value that is associated to each row and column (row 1 and column 1 for example) in a database and I have loaded</p> <p>them into QLikView. But you can only define columns for the Table Box object in QLikView. How can I create more complex Table Boxes in QLikView? </p> <p> </p> <p>Thanks alot for your help[:)]</p> <p>Naeemeh</p> <p> </p> <p> </p> <p><col width="215"></col><col span="2" width="64"></col></p> <p> </p></body>
Sure. You need to create a chart with Pivot Table type:
Dimesions: RowNames, ColumnName1, ColumnName2
Expression: a group function for Value, like sum(Value)
Sure. You need to create a chart with Pivot Table type:
Dimesions: RowNames, ColumnName1, ColumnName2
Expression: a group function for Value, like sum(Value)
I agree with Nick, you can use pivot table and move the field ColumnName from vercital axis to horizontal axis.
[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/5807.Table.zip:550:0]