Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Hamdi_G
Contributor III
Contributor III

QlikSense equivalent of lag over partition

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, 

Labels (2)
5 Replies
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
Contributor III
Contributor III
Author

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

Ksrinivasan
Specialist
Specialist

hi,

can you explain the same sql in Excel formula,

ksrinivasan.