Please help me ASAP

[#1]

Dear all,

      I am new in Qlikview, I have a problem in script i.e., I have 5 excels data for each location

Please find the below sample script

CrossTable(Questions, Grooming_GENTS_Scores, 5)

LOAD Date,

     [Name of the Associate],

     [Ticket Number],

     Department,

     [Name of the Auditor],

     [Hair should be short and neatly cut, and should not fall on the forehead.],

     [The face should have a clean look with no stubble.],

     [Mustaches must be neatly trimmed and should not cover the upper lip.],

     [Sideburns should not be shorter than the top of the ear and no longer than the bottom of the ear lobe.],

     [The hair do must be neat using the regulation gel and back should be 2 inches above the shirt collar],

     [Nails are neatly cut, shaped and clean.],

     [Fingernails should be clean and dirt free.  no nicotine, carbon or ink stains on the fingers.],

     [No bracelets or bands allowed],

     [Shoes must be as per regulation ,polished and in good repair.],

     [Socks should match the color of the shoes.Socks should be odorless and clean with elastic intact],

     [Belts must be black and not thicker than 1.5 inchs],

     [Uniform should be spotless with no stains.],

     [There should be no loose threads, broken buttons  tears.],

     [Cuffs and collars should not be stained.],

     [I D Cards should be clean bright and prominently displayed with a spotless strap],

     [A vest should always be worn.],

     [Perfumes and deodorants  as per regulations should be mild and used sparingly.],

     [Teeth should be stain free and free from bad breath.]

FROM

[..\Grooming_Audit_$(filename)_AMH.xlsx]

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

Transpose(),

Remove(Row, RowCnd(Interval, Pos(Top, 1), Pos(Top, 2), Select(2, 2)))

));

IF scripterror=8 then

EXIT Script;

ENDIF;

Please find the attachment sample application. My problems are listed below

   1. I schedule the application for every month here I have a problem i.e.,when I reload this month data some issues are placed in the source format for one location the script is going to be exit. I dont know what's the problem in script. If it has any wrong in script please Guide me.

  2.My requirement is If any location source format is wrong then skip that location script and continue to reload the remaining script.

[#2]

Hey i didnt understand ur issue

can u pls send the source file and the qvd

also didnt understand y r u repeating the code again and again in the script

also on line 526, there is mistake in copy paste

the source extension is repeated .xlsx twice tht might b the issue

hope tht solves ur problem

also send the source file.............

[jagan]

Hi,

As Prashant said, in Line 526

I think it should be

Hope this helps you.

Also please find attached files, it is working as expected.

Regards,

Jagan.

[#4]

Hey jagan, can u pls explain me portion of the above code posted,

didnt understand the positiions and the need whn using crosstable

Transpose(),

Remove(Row, RowCnd(Interval, Pos(Top, 1), Pos(Top, 2), Select(2, 2)))

[jagan]

Hi Prashant,

I am not sure about this, I think you will get this options by using Transformation Setup while importing Excel file.  I will try and let you know.

Regards,

Jagan.