Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Kindly help me in creating the script for this data.

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
ABC
Calls
14161242
Follow-upLater 1061026

Not Interested410216
[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..

Tags (3)
1 Solution

Accepted Solutions
msheraton
Contributor III

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

See V3 attached

6 Replies
sujeetsingh
Honored Contributor III

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

Seems i got confussed plz provide a sample.

Not applicable

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

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.

msheraton
Contributor III

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

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

Mark

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

Not applicable

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

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

msheraton
Contributor III

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

See V3 attached

Not applicable

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

Thumbs Up.. !!

You solved my problem.

Many thanks again..