Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
adnan_rafiq
Partner - Creator II
Partner - Creator 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.

9 Replies
swuehl
MVP
MVP

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
Partner - Creator II
Partner - Creator II
Author

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.

jonathandienst
Partner - Champion III
Partner - Champion III

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
Partner - Creator II
Partner - Creator II
Author

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

swuehl
MVP
MVP

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?

Anonymous
Not applicable

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
Partner - Creator II
Partner - Creator II
Author

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
Partner - Creator II
Partner - Creator II
Author

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

swuehl
MVP
MVP

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?