Create a cross tab with charts as its facts

[#1]

Hello

I want to create a cross tab report which looks like this

	Portfolio1	Portfolio2	Portfolio3
Month1	Chart1	Chart2	Chart3
MOnth2	Chart1	Chart2	Chart2
Month3	Chart1	Chart3	Chart3

Here Month 1 and Portfolio are dimensions.

Chart has to be placed, which will be calculated based on values of Month and Count of Portfolio.

I tried using pivot table, but dont know how to add dimension to column section of cross tab.

Please let me know anyone has any idea on how to do it.

Thanks

Ankit

[Gysbert_Wassenaar]

You can use the trellis option. Pick the chart type you want and on the Dimension tab click on Trellis and check Enable Trellis Chart and Enable Secondary Trellis Dimension. The first two dimensions you add are for the Trellis axes. The rest of the dimensions and expressions you add are for the charts displayed in the trellis grid.

[#3]

Hello Gysbert

Appreciate your quick reply.

Using Trellis reallly helped but still I am not able to acheive final output.

I am new to QlikView.

Like other BI Toools, does QlikView has functions that aggregates facts based on some scope, like using partition by clause in SQL.

If I have loaded data using a spreadsheet, then after loading can I write SQL on the data loaded, to convert data as per my requirements.

Please let me know if we have such functions in Qlikview.

Thanks

Ankit