representation in table

Tue, 04 Sep 2012 06:51:16 GMT

Hi All,

I got a new requirement from my client, they want sales report in a tabler representation based on the geo(dimension) and product wise.

Please find the attachment, it is showing the metrics will comes under the perticular column names in the report.

I know that we can give the metrics based on the perticular products or dimensions.but my question is, how can we represent the product-1.

And we can see the product-1 it is having 5 categories Jul'12,YTD Ju'12,Jul'11,Dec'11 and growth% over and again i have3 categories in Jul'12 and YTD Jul'12.

How can we represent this in qlikview,can anyone having the idea about this.

Product-1
Jul'12			YTD Jul'12					Growth % Over
Sales	Target	% Ach	Sales	Target	% Ach	Jul'11	Dec'11	Average	YTD

regards,

baru

topic representation in table in QlikView

representation in table