How to get format

rohit214 — Tue, 17 Jan 2012 09:32:22 GMT

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.	Dealer Name	Dealer Code	Region	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

How to get format

Anonymous — Tue, 17 Jan 2012 10:24:39 GMT

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

topic How to get format in QlikView

How to get format

How to get format