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.
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.