Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

sureshqv
Esteemed Contributor III

RE:Rows to column

hi all...

i hve data with rows like'

Revenue bucketForecsatRevRegionCustomerCommentsRevTermsPeriodWeek

       

firm123aAxxfabcd15_Q433
qtdsles122bBgdsgabcd13_Q334
risk_h34cCfffdsff11_Q335
risk_l55dDgggd10_Q433
ups_h66sEgghf11_Q334
ups_l78eFgsfhh15_Q335
firm123aAxxfabcd15_Q433
qtdsles122bBgdsgabcd13_Q334
risk_h34cCfffdsff11_Q335
risk_l55dDgggd10_Q433
ups_h66sEgghf11_Q334
ups_l78eFgsfhh15_Q335

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

Revenue bucketForecsatRevRegionCustomerCommentsRevTermsPeriod

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?

1 Solution

Accepted Solutions

Re: RE:Rows to column

Hi Suresh,

Do you need the Revenue Bucket in Dimension also?

Not sure, But May be check this ..

Capture.JPG

16 Replies

Re: RE:Rows to column

Hi Suresh,

Can you post the sample data?

sureshqv
Esteemed Contributor III

Re: RE:Rows to column

PFA

sample excel file

ahmar811
Contributor III

Re: RE:Rows to column

hi suresh

i think your out like this please refer attach file

Capture.JPG

hope this help you

Regards

Ahmar

raajaswin
Contributor III

Re: RE:Rows to column

May be this?

sureshqv
Esteemed Contributor III

Re: RE:Rows to column

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

like

33               34                       

firm          qtdsale

risk_l       ups_h

firm

lik dat...

sureshqv
Esteemed Contributor III

Re: RE:Rows to column

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

Re: RE:Rows to column

Hi Suresh,

Do you need the Revenue Bucket in Dimension also?

Not sure, But May be check this ..

Capture.JPG

ahmar811
Contributor III

Re: RE:Rows to column

like that

Capture.JPG

sureshqv
Esteemed Contributor III

Re: RE:Rows to column

Hi settu,

Is it possible to hide the empty week row?

Community Browser