QlikSense equivalent of lag over partition

[Hamdi_G]

Hello, 

Can any one help me how to write this sql expression in qlik sense : 

case
when (lag(e.largeur,1,0) over (partition by es.numero_alveole order by es.numero_alveole, indice_alveole))=2
or (lead(e.largeur,1,0) over (partition by es.numero_alveole order by es.numero_alveole, indice_alveole))=2
then 1
else 0
end as is_grille,

thanks, 

[OmarBenSalem]

don't change a thing .. you can use ur sql code in qlik sense 

[OmarBenSalem]

that said, you can check out the previous() function in qlik sense 

[Hamdi_G]

no i need to write it with load expression because my data are in QVD Files .

[OmarBenSalem]

Please check out this : https://help.qlik.com/en-US/sense/November2020/Subsystems/Hub/Content/Sense_Hub/Scripting/InterRecor...

[Ksrinivasan]

hi,

can you explain the same sql in Excel formula,

ksrinivasan.