Solved: Help : Left join date max - Qlik Community

MDE_PF · ‎2022-03-03

Bonsoir à tous,

J'ai besoin de votre aide svp sur ce script qui ne me donne pas le résultat attendu.

En effet, je cherche à alimenter une colonne Flag avec un '1' à chaque fois que la date maximum pour le parc_ID est concernée.

Pourriez-vous svp m'aiguillez sur l'erreur potentiel dans mon script ??

Un grand merci !!

hic · ‎2022-03-04

Two errors:

First, the $(max("Date Effet Releve Km")) in the where clause will not work. You cannot use aggregation functions inside dollar expansions in the script. However, I don't think that the where clause is needed: The Left Join should take care of the filtering.

Secondly, you cannot have "Date Effet Releve Km" in your "Group By" if you at the same time want to calculate the Max("Date Effet Releve Km"). There is only one value of "Date Effet Releve Km" within each group.

View solution in original post

hic · ‎2022-03-04

Two errors:

First, the $(max("Date Effet Releve Km")) in the where clause will not work. You cannot use aggregation functions inside dollar expansions in the script. However, I don't think that the where clause is needed: The Left Join should take care of the filtering.

Secondly, you cannot have "Date Effet Releve Km" in your "Group By" if you at the same time want to calculate the Max("Date Effet Releve Km"). There is only one value of "Date Effet Releve Km" within each group.

Help : Left join date max

SaaS