How to get format

[rohit214]

Hi all

my Client want to see data in given below format while exporting the table from qlikview

No.	Dealer Name	Dealer Code	Region	Q8.   Please rate your overall service experience
				No of Customers for the month	No   of Customers Rating (1-7)	No   of Customers Rating (9-10)	%   Customers Rating (1-7)	%   Customers Rating (9-10)
1	Dealer 1	Code 1	Region 1	21	10	9	48%	43%
2	Dealer 2	Code 2	Region 2	22	11		50%	0%
3	Dealer 3	Code 3	Region 3	23	12		52%	0%
4	Dealer 4	Code 4	Region 4	24	10		42%	0%

So for getting this type of format how do can i modify my table

thanks

rohit

[Anonymous]

Dear Rohit,

you take the dimension as no, Delarname, Delar code, Region and question no,then you drag question no column towards upper right.that time you will get this format and remaining is expression.if you select question no 8 in list box it will reflect only Q8 in the chart.

thanks

Arun Reddy