Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

adnan_rafiq
Contributor II

Changing header size of QVD

Hi Gurus,

Is there a way that we can possibly change the header size of a QVD?, all views appreciated.

Tags (2)
9 Replies
MVP
MVP

Re: Changing header size of QVD

Could you elaborate further on what you envision here?

Do you want to enlarge or shrinken the header size?

Any specific elements?

Maybe have a look at

Re: Large number of irrelevant entries in QVD MetaData header

QVD File Size in QV11

adnan_rafiq
Contributor II

Re: Changing header size of QVD

My vision is, that i have a qvd and in order to crosstable it, I use its given header, but I need to crosstable it again in order to load the 2nd header for that I need to change the header line.

MVP
MVP

Re: Changing header size of QVD

It still not very clear what you need. Perhaps you can supply a a sample QVD and a detailed explanation of the result you need.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
adnan_rafiq
Contributor II

Re: Changing header size of QVD

Here is the sample QVD. I want the desired result to be like the picture below. The way i tried to get this was by 2 crosstables one for month value and other for Department value. As month was captured by first cross table but to capture the dept need help to change the header line and then crosstable is to capture Dept values. I hope I am making my point clear

Result.png

MVP
MVP

Re: Changing header size of QVD

I think the best way to achieve what you want is to correct the load script that generated this QVD.

Could you post the script that created the table that was stored into the QVD? Or the source table file?

Re: Changing header size of QVD

You could extract things from the qvd with something like the below and then attempt to do some jiggery pokery to get it how you want it.

But as suggested above it would be a quicker and more robust to sort [CT solution.qvw] that created

QvdFieldHeader:

load

  Rowno() as DateColumnNumber ,

  date ( floor ( FieldName ) ) as DateHeader

where not match ( FieldName , 'F1' , 'F2' )

;

LOAD FieldName

FROM Initial.qvd (XmlSimple, Table is [QvdTableHeader/Fields/QvdFieldHeader]);

LOB:

LOAD F1,

     F2,

     [42430.000000],

     [42430.0000001],

     [42430.0000002],

     [42430.0000003],

     [42401.000000],

     [42401.0000001],

     [42401.0000002],

     [42401.0000003]

FROM

Initial.qvd

(qvd)

Where F1 = 'LOB'

;

qualify * ;

Data:

LOAD 

     [42430.000000],

     [42430.0000001],

     [42430.0000002],

     [42430.0000003],

     [42401.000000],

     [42401.0000001],

     [42401.0000002],

     [42401.0000003]

FROM

Initial.qvd

(qvd)

Where not F1 = 'LOB';

Dept :

LOAD 

     F1,

     F2

FROM

Initial.qvd

(qvd)

Where not F1 = 'LOB';

adnan_rafiq
Contributor II

Re: Changing header size of QVD

Hi swuehl‌ . Here is the script and xls.

Initial:

LOAD *

FROM

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

Transpose(),

Replace(1, top, StrCnd(null)),

Replace(2, top, StrCnd(null)),

Transpose()

));

STORE Initial into Initial.qvd(qvd);

Drop Table Initial;

adnan_rafiq
Contributor II

Re: Changing header size of QVD

But to my earlier question. can i change the header lines of a qvd?

MVP
MVP

Re: Changing header size of QVD

I'm unsure what you mean with 'header lines' here.

Don't you want to manipulate records in the table (i.e. cell (2,1), (2,2)), not the header?

Community Browser