Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I am new to Qlikview
Difference between Peek and Previous Function give me an example
plz help.
Peek() looks in your destination table but Previous() refers to your source table.
Consider this script:
TMP:
LOAD * inline [
FIELD
A
B
C
D
E
];
LOAD
'#' & RowNo() & FIELD as FIELD ,
FIELD as [Original],
Peek(FIELD) as [Peek],
Previous(FIELD) as [Previous]
Resident TMP;
DROP TABLE TMP;
The output will look like this:
Peek() looks in your destination table but Previous() refers to your source table.
Consider this script:
TMP:
LOAD * inline [
FIELD
A
B
C
D
E
];
LOAD
'#' & RowNo() & FIELD as FIELD ,
FIELD as [Original],
Peek(FIELD) as [Peek],
Previous(FIELD) as [Previous]
Resident TMP;
DROP TABLE TMP;
The output will look like this:
https://www.qliktastic.com/2016/02/08/qlikview-previous-and-peek-are-not-the-same/
Go through this article. It will help you for your answer