Load the input file in QVW

[#1]

Dear QV Expert,

I have an input file which has Quater, Month & the Dimensions.

Can you please suggest me either we need to Transpose or CrossTable?

Requirement:

Quarter, Month are in List Box. Selecting should display,Volume, Achieved & Perf%

Appreciate your prompt response.

Thanks

[Kushal_Chawda]

perhaps you need this

multi_header_pivot_import.qvw

[#3]

Thanks Kush

[Anonymous]

see the thread shared by Kush, it will be helpful for you

[#5]

Dear QV Experts,

Also used this option below & worked as expected.

CrossTable(Supply, Data, 2)

LOAD [Pre-development enquiry] as Month,

     [Pre-development enquiry1] as Metrics,

     Supply,

     Sewerage,

     [S45 connections],

     [S45 application ack.],

     [S45 quotation sent out (no. of plots)],

     [S41 application ack],

     [S41 quotation sent out < 500 plots],

     [S41 quotation sent out >500 plots],

     [Mains constructed (schemes)],

     [Self lay application ack.],

     [Sel lay quotations],

     [Sel lay connections (no.of plots)],

     [Sewer requistion application ack],

     [S104/S185 application ack.],

     [S104/S185 application reply],

     [S104 agreement sent out],

     [S106 technical approval],

     [S106 rejection]

FROM

[.\DataInput.xlsx]

(ooxml, embedded labels, table is Sheet1, filters(

Remove(Row, Pos(Top, 35)),

Remove(Row, Pos(Top, 34)),

Remove(Row, Pos(Top, 33)),

Remove(Row, Pos(Top, 32)),

Remove(Row, Pos(Top, 29)),

Remove(Row, Pos(Top, 27)),

Remove(Row, Pos(Top, 24)),

Remove(Row, Pos(Top, 22)),

Remove(Row, Pos(Top, 18)),

Remove(Row, Pos(Top, 16)),

Remove(Row, Pos(Top, 12)),

Remove(Row, Pos(Top, 9)),

Remove(Row, Pos(Top, 7)),

Remove(Row, Pos(Top, 6)),

Remove(Row, Pos(Top, 1)),

Replace(1, left, StrCnd(null)),

Replace(3, left, StrCnd(null)),

Replace(4, left, StrCnd(null)),

Replace(6, left, StrCnd(null)),

Replace(7, left, StrCnd(null)),

Replace(9, left, StrCnd(null)),

Replace(10, left, StrCnd(null)),

Replace(12, left, StrCnd(null)),

Replace(13, left, StrCnd(null)),

Replace(15, left, StrCnd(null)),

Replace(16, left, StrCnd(null)),

Replace(18, left, StrCnd(null)),

Replace(19, left, StrCnd(null)),

Replace(1, bottom, StrCnd(null)),

Transpose()

));