Load the input file in QVW

Fri, 27 Nov 2015 05:59:14 GMT

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

Re: Load the input file in QVW

Kushal_Chawda — Fri, 27 Nov 2015 06:05:00 GMT

perhaps you need this

multi_header_pivot_import.qvw

Re: Load the input file in QVW

Fri, 27 Nov 2015 06:11:25 GMT

Thanks Kush

Re: Load the input file in QVW

Anonymous — Fri, 27 Nov 2015 06:13:04 GMT

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

Re: Load the input file in QVW

Fri, 27 Nov 2015 10:04:17 GMT

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()

));

topic Re: Load the input file in QVW in QlikView

Load the input file in QVW

Re: Load the input file in QVW

Re: Load the input file in QVW

Re: Load the input file in QVW

Re: Load the input file in QVW