Invalid expression

[#1]

Hello,

What is my error in this script?

The tables Itab2 and fichier are ok but i have an "Invalid expression" concerning Itab3.

And i know this is not about my where clause, i got this error even if i remove it.

Does anyone see a mistake there?

Itab2:

LOAD [Hiérarchie produit],

Division,

Magasin,

sum(Stock) as [Stock cumulé],

peek('var', 0, 'VARIABLE') as Date

Resident Itab

Group by [Hiérarchie produit], Division, Magasin

Order by [Hiérarchie produit], Division, Magasin;

DROP Table Itab;

Drop table VARIABLE;

fichier:

LOAD @1 as Hiérarchies

FROM

C:\Qlikview\fich_config.txt(ansi, txt, no labels);

Itab3:

LOAD [Hiérarchie produit],

Division,

Magasin,

sum([Stock cumulé]) as [Stock divmag],

Date

Resident Itab2

Where [Hiérarchie produit] <> peek('Hiérarchies', 0, 'fichier') and

[Hiérarchie produit] <> peek('Hiérarchies', 1, 'fichier') and

[Hiérarchie produit] <> peek('Hiérarchies', 2, 'fichier') and

[Hiérarchie produit] <> peek('Hiérarchies', 3, 'fichier') and

[Hiérarchie produit] <> peek('Hiérarchies', 4, 'fichier') and

[Hiérarchie produit] <> peek('Hiérarchies', 5, 'fichier')

Group by Division, Magasin

Order by [Hiérarchie produit], Division, Magasin;

DROP Table Itab2;

Thanks,

Regards,

Loïc

[hic · Accepted solution]

You are missing [Hiérarchie produit] and Date in the Group By clause.

HIC

[MayilVahanan]

Hi

You need to add following fields

[Hiérarchie produit],

Division,

Magasin,

Date

in Group by clause in ltab3