Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Invalid expression

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

1 Solution

Accepted Solutions

Re: Invalid expression

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

HIC

2 Replies

Re: Invalid expression

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

HIC

Re: Invalid expression

Hi

You need to add following fields


[Hiérarchie produit],

Division,

Magasin,

Date

in Group by clause in ltab3