topic Re: Script error in QlikView

Script error

Tue, 14 Oct 2014 15:41:20 GMT

Hello,

Could someone tell me what's wrong with this script please?

vSourcePath

'..\1. Sources';

AssAuto:

LOAD [Nom garage],

[Date de création],

count([Nom garage])as Counting

FROM

'$(vSourcePath)\Ass Auto Marsh.xlsx'

(ooxml, embedded labels, table is [Ass Auto Marsh]);

Thank you

Re: Script error

alexandros17 — Tue, 14 Oct 2014 15:43:15 GMT

Could you tell what kind of error returns the script?

Re: Script error

shanky1907 — Tue, 14 Oct 2014 15:44:23 GMT

What Error are you getting exactly?

Re: Script error

Tue, 14 Oct 2014 15:45:59 GMT

I've got this message:

Invalid expression

AssAuto:

LOAD [Nom garage],

[Date de création],

count([Nom garage])as Counting

FROM

'..\1. Sources\Ass Auto Marsh.xlsx'

(ooxml, embedded labels, table is [Ass Auto Marsh])

Re: Script error

Tue, 14 Oct 2014 15:46:36 GMT

I've got this message:

Invalid expression

AssAuto:

LOAD [Nom garage],

[Date de création],

count([Nom garage])as Counting

FROM

'..\1. Sources\Ass Auto Marsh.xlsx'

(ooxml, embedded labels, table is [Ass Auto Marsh])

Re: Script error

alexandros17 — Tue, 14 Oct 2014 15:47:33 GMT

The problem is that you caanot execute a count without a group by ...

Re: Script error

Anonymous — Tue, 14 Oct 2014 15:48:23 GMT

Hello!

you can try it!

SET vSourcePath='..\1. Sources\';

AssAuto:

LOAD [Nom garage],

[Date de création],

count([Nom garage])as Counting

FROM

$(vSourcePath)Ass Auto Marsh.xlsx

(ooxml, embedded labels, table is [Ass Auto Marsh]);

Re: Script error

MK_QSL — Tue, 14 Oct 2014 15:51:40 GMT

Use anyone of below

Let vSourcePath

'..\1.Sources';

Data:

LOAD [Nom garage],

[Date de création],

COUNT([Nom garage]) as Counting

FROM

[$(vSourcePath).xlsx]

(ooxml, embedded labels, table is [Ass Auto Marsh])

Group By [Date de création],[Nom garage];

Let vSourcePath

'..\1.Sources';

Data:

LOAD

[Date de création],

COUNT([Nom garage]) as Counting

FROM

[$(vSourcePath).xlsx]

(ooxml, embedded labels, table is [Ass Auto Marsh])

Group By [Date de création];

Re: Script error

Tue, 14 Oct 2014 15:55:34 GMT

You right!

I 've write "Group By [Nom garage],[Date de création] ;"

and it's working

thank you very much