topic Re: Kindly help me in creating the script for this data. in QlikView

Kindly help me in creating the script for this data.

Tue, 21 May 2013 07:55:27 GMT

Hi,

I have to write a script for this sort of data. how it would be possible?

As this is just a dummy data which i have on my excel sheet.

I have multiple sheets all containting the same number of fields but with different dates.

For the month of JAN					Total
Shift		A	B	C
Calls		14	16	12	42
Follow-up	Later	10	6	10	26
	Not Interested	4	10	2	16
[Day:Tuesday 01/01/2013]

I wrote up this simple script :

LOAD Shift,

Calls,

[Follow-up],

[Day:TUSEDAY 01/01/2013] as Day

FROM

(ooxml, embedded labels, header is 1 lines, table is [1 JAN], filters(

Transpose(),

));

But Follow-Up fields contain two Sub-fields (Later,Not interested) and kindly help me with the date aswell.

Please help me in creating the correct script.

Thanks..

Re: Kindly help me in creating the script for this data.

sujeetsingh — Tue, 21 May 2013 08:31:57 GMT

Seems i got confussed plz provide a sample.

Re: Kindly help me in creating the script for this data.

Tue, 21 May 2013 11:11:20 GMT

Please review the attached file as i forgot to attach it earlier. i hope so it will be presenting a more clear picture now.

Thanks.

Re: Kindly help me in creating the script for this data.

RedSky001 — Tue, 21 May 2013 16:00:30 GMT

See the attached file, let me now of this helps?

Mark

(edit I've attached a version 2, this loops through the work sheets)

Re: Kindly help me in creating the script for this data.

Wed, 22 May 2013 05:12:09 GMT

Many thanks Mark.

You solved my problem to some extent, but still i am unable to lookup the 'Later' and 'Not interested' field, as if we delete the first row after transposing then these two fields will get deleted aswell.

The Follow-up field consists of two different fields "Later and Not-Interested", its more likely hierarchical.

I want to compute these two fields separately.

Seeking guidance from you.

Many thanks again.

Regards,

Hassam

Re: Kindly help me in creating the script for this data.

RedSky001 — Wed, 22 May 2013 09:42:28 GMT

See V3 attached

Re: Kindly help me in creating the script for this data.

Wed, 22 May 2013 10:08:02 GMT

Thumbs Up.. !!

You solved my problem.

Many thanks again..