Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
try
Date(num#(TargetMonth),'DD/MM/YYYY') as %DateKey
Regards
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
Hi Johan,
I just tried that but still no luck.
Any other suggestions please?
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;
nope. no luck
Hi,
try
Date(num#(TargetMonth),'DD/MM/YYYY') as %DateKey
Regards
Hi Laura,
What are your date settings in the document? Do those correspond to the input in your inline load ?
Johan
OMG thank-you . please tell me this get's easier 🙂
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;
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