topic Re: Three dimensions and one expression- suggest layout/chart in QlikView

Three dimensions and one expression- suggest layout/chart

Tue, 10 Sep 2013 00:50:03 GMT

Hi All,

I need suggestions for below requirement:

I have to design a chart/visible layout for frequency of purchases by product by brand by region.

Customers would like to compare performance of brand relative to product and region.

Please suggest me which chart layout is better and how it is useful

Thanks in advance,

Ramesh

Re: Three dimensions and one expression- suggest layout/chart

Gysbert_Wassenaar — Tue, 10 Sep 2013 17:31:01 GMT

You can try a block chart. That's one of the few charts that supports three dimensions. Or perhaps a mecko chart or grid chart, in combination with enabling the Trellis option (on the Dimensions tab).

Another thing you can try is create a calculated dimension by concatenating two of the three dimensions. For example =[Brand] & '-' & [Product]. That way you end up with two dimensions (the calculated dimension and the remaining dimension) which gives you more options for using different chart types.

Re: Three dimensions and one expression- suggest layout/chart

Wed, 11 Sep 2013 04:01:57 GMT

Thanks Wassenaar

I implemented block chart and it did not come up visual feed good one.. I will try Trellis (option ) - which is new and thumbs high for sharing such a useful info.