topic Pivot table in QlikView

Pivot table

emteam162 — Fri, 16 Nov 2012 09:05:41 GMT

Hi,

I want create pivot table like

		Cont		Conv
Section	Service	montant	numbre	montant
a	id1	30	0	1
b	id2	6	0	0
c	id3	21	0	33
a	id4	105	0	4
b	id5	17	0	5
c	id6	20	0	7
a	id7	3	0	1
b	id8	37	0	6
c	id9	136	0	5
a	id10	18	0	164
b	id11	0	0	91
c	id12	9	0	32
a	id13	37	0	14
b	id14	75	0	6
Total		514	0	369

But i can't do that i have this pivot table

		Cont
Section	Service	montant	numbre	numbre
a	id1	30	0	null
b	id2	6	0	null
c	id3	21	0	null
a	id4	105	0	null
b	id5	17	0	null
c	id6	20	0	null
a	id7	3	0	null
b	id8	37	0	null
c	id9	136	0	null
a	id10	18	0	null
b	id11	0	0	null
c	id12	9	0	null
a	id13	37	0	null
b	id14	75	0	null
Total		514	0

There are a way to hide column with value null

Many thanks for your help.

Best regards,

Emteam

Re: Pivot table

emteam162 — Fri, 16 Nov 2012 14:16:43 GMT

HI,

Any Help??

Best Regards,

Emteam

Re: Pivot table

shree909 — Fri, 16 Nov 2012 16:28:14 GMT

Hi ,

write some if condition for the null

if( number = null ,0)

Re: Pivot table

emteam162 — Fri, 16 Nov 2012 16:51:08 GMT

Hi,

thanks for your replay,

But dosn't work your solution.

Please, can you attach a sample example.

Many thanks

Emteam

Re: Pivot table

CELAMBARASAN — Fri, 16 Nov 2012 17:29:48 GMT

Hi,

Check the attached.

Re: Pivot table

emteam162 — Mon, 19 Nov 2012 09:52:57 GMT

Hi Celambarasan,

Thanks you for your replay.

it works at display but when you make a selection the last column are hide.

Normally i will have this :

	''	Cont	Conv	Conv
F4	F2	Nb d	Nb d	Nb T
test1	a	1	1	0

but when i make the selection i have this :

	''	Cont	Conv
F4	F2	Nb d	Nb d
test1	a	1	1

Best Regards,

Emteam

Re: Pivot table

emteam162 — Mon, 19 Nov 2012 17:13:08 GMT

Hi,

Any idea ???

Best Regards,

Emteam