Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You are missing [Hiérarchie produit] and Date in the Group By clause.
HIC
You are missing [Hiérarchie produit] and Date in the Group By clause.
HIC
Hi
You need to add following fields
[Hiérarchie produit],
Division,
Magasin,
Date
in Group by clause in ltab3