Assistance with trouble shooting

[Anonymous]

Hi All,

I'd like to understand how to trouble shoot the attached issue of data loading into the table but not into the QlikView.dashboard.  Any assistance appreciated please.

[puttemans]

Hello Laura,

Please try Date(Date#(TargetMonth,'DD/MM/YYYY')) as %DateKey, in your script.

I think you now try to link a date-number with a date-string in your inline load.

Regards,

Johan

[Anonymous]

Hi Johan,

I just tried that but still no luck.

Any other suggestions please?

[Digvijay_Singh]

See if this can help -

Temp_Targets:

CrossTable(TargetMonth, Target, 3)

LOAD ConsultantName,

    team_id,

    id,

    [42186] as [July-15],

    [42217] as [Aug-15],

    [42248] as [Sep-15],

    [42278] as [Oct-15],

    [42309] as [Nov-15],

    [42339] as [Dec-15]

FROM

TeamConsultantTargets.xlsx

(ooxml, embedded labels, table is Sheet1);

Target:

LOAD

id as %ConsultantKey,

TargetMonth,

Target

Resident Temp_Targets;

DROP table Temp_Targets;

[Anonymous]

nope.  no luck

[PrashantSangle · Accepted solution]

Hi,

try

Date(num#(TargetMonth),'DD/MM/YYYY') as %DateKey

Regards

[puttemans]

Hi Laura,

What are your date settings in the document? Do those correspond to the input in your inline load ?

Johan

[Anonymous]

OMG thank-you .  please tell me this get's easier 🙂

[Digvijay_Singh]

I think I misunderstood the need, do you mean you need to get inline load work? try like this -

Normally the Date format at the top provided by QV and what we use in script conflicts so data loading impacted, we need to use Date(Date# combination to interpret the data and then format the way we want.

LOAD *, Date(Date#(%DateKey,'DD/MM/YYYY'),'DD/MM/YYYY') as %DateKey1  INLINE [

    Date, Target, %ConsultantKey

    01/07/2015, 70, 483

    01/08/2015, 50, 483]

    ;

DROP table Temp_Targets;

[PrashantSangle]

Hi,

when you use cross table concept with date field.

then your datefield is converted in text therefore you need to use num#() to convert it again in number

Regards