Table

[#1]

Hi Friends,

I'd like to be able to display something like this

	MS1	MS2	MS3
Q1	1	0	1
Q2	1	0	1
Q3	1		1
Q4	1	1	1

SQL db table structure is like this

Q1	Q2	Q3	Q4	MS	DELAER	COUNTRY
1	1	1	1	MS1
0	0		1	MS2
1	1	1	1	MS3

How can i do this.

I am using the personal edition and this is first report in Qlikview.

Appreciate if some one could help me in this.

Many Thanks,

Selva

[#2]

Thank you Gysbert Wassenaar

I got it

[#3]

Hi Gysbert,

i am facing a problem, if one of the question is null or empty, pivot table is not displaying it. i need to display it as N/A.

Please help me.

Thanks,
Selva