topic Re: RE:Rows to column in QlikView

RE:Rows to column

Chanty4u — Thu, 17 Dec 2015 15:12:41 GMT

hi all...

i hve data with rows like'

Revenue bucket

ForecsatRev

Region

Customer

Comments

RevTerms

Period

Week

firm	123	a	A	xxf	abcd	15_Q4	33
qtdsles	122	b	B	gdsg	abcd	13_Q3	34
risk_h	34	c	C	fff	dsff	11_Q3	35
risk_l	55	d	D	g	ggd	10_Q4	33
ups_h	66	s	E	gg	hf	11_Q3	34
ups_l	78	e	F	gsf	hh	15_Q3	35
firm	123	a	A	xxf	abcd	15_Q4	33
qtdsles	122	b	B	gdsg	abcd	13_Q3	34
risk_h	34	c	C	fff	dsff	11_Q3	35
risk_l	55	d	D	g	ggd	10_Q4	33
ups_h	66	s	E	gg	hf	11_Q3	34
ups_l	78	e	F	gsf	hh	15_Q3	35

i hve data above ...but i want oonly WEEK row as

Revenue bucket

ForecsatRev

Region

Customer

Comments

RevTerms

Period

33 34 35

and Revenue bucket is my measure...? i want that values in week column like pivot table

how can i achieve dis in pivot table?

Re: RE:Rows to column

settu_periasamy — Fri, 18 Dec 2015 03:13:14 GMT

Hi Suresh,

Can you post the sample data?

Re: RE:Rows to column

Chanty4u — Fri, 18 Dec 2015 04:00:33 GMT

PFA

sample excel file

Re: RE:Rows to column

ahmar811 — Fri, 18 Dec 2015 04:42:35 GMT

hi suresh

i think your out like this please refer attach file

hope this help you

Regards

Ahmar

Re: RE:Rows to column

raajaswin — Fri, 18 Dec 2015 04:46:22 GMT

May be this?

Re: RE:Rows to column

Chanty4u — Fri, 18 Dec 2015 04:53:06 GMT

thnx ahmar.....but i need the revenue_bucket values under weeks with respective week..

33 34

firm qtdsale

risk_l ups_h

firm

lik dat...

Re: RE:Rows to column

Chanty4u — Fri, 18 Dec 2015 04:54:01 GMT

in pivot table only....but with in that week the corresponding vales to be displayed lik pivot values

Re: RE:Rows to column

settu_periasamy — Fri, 18 Dec 2015 05:13:21 GMT

Hi Suresh,

Do you need the Revenue Bucket in Dimension also?

Not sure, But May be check this ..

Re: RE:Rows to column

ahmar811 — Fri, 18 Dec 2015 05:20:00 GMT

like that

Re: RE:Rows to column

Chanty4u — Fri, 18 Dec 2015 05:22:45 GMT

Hi settu,

Is it possible to hide the empty week row?

Re: RE:Rows to column

ahmar811 — Fri, 18 Dec 2015 05:25:14 GMT

like that suresh

Re: RE:Rows to column

Chanty4u — Fri, 18 Dec 2015 05:38:34 GMT

but user need.....wen he clicks on 33...he wants lik +symbol to get the revenue bucket values

Re: RE:Rows to column

Kushal_Chawda — Fri, 18 Dec 2015 05:41:13 GMT

see the attached

Re: RE:Rows to column

Chanty4u — Fri, 18 Dec 2015 05:45:25 GMT

no kush....

i want wen i clik on 33 it will expand the values within that revenue bucket

Re: RE:Rows to column

ahmar811 — Fri, 18 Dec 2015 05:57:12 GMT

sorry sureshqv but it is not possible expand the values within that revenue bucket..

Re: RE:Rows to column

Chanty4u — Fri, 18 Dec 2015 06:05:13 GMT

Hmm thnx ahmar

Re: RE:Rows to column

raajaswin — Fri, 18 Dec 2015 06:47:08 GMT

May be this?