
Contributor
2023-06-29
02:51 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Working of PEEK and PREVIOUS Functions
In the below script wanted to know the difference between Peek and Previous functions
So when Iam trying that, the end result is same for both functionalities. Could anyone of you please help me with this.
Test:
load
Distinct(Month) as Month_1,
SaleAmount,
Previous(SaleAmount) as Previousamount,
peek(SaleAmount) as Peek_amount;
test1:
load *
Inline [
Month,SaleAmount
Jan,100
Feb,200
Mar,300
Apr,400
May,500
Jun,600
Jun,600
];
Output for the script :
Labels (7)
Labels
- Subscribe by Topic:
-
Data Load Editor
-
Developers
-
expression
-
General Question
-
Script
-
Set Analysis
-
Visualization
1,057 Views
1 Solution
Accepted Solutions

MVP
2023-06-29
03:00 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
There is a detailed explanation of the difference here
https://www.naturalsynergies.com/q-tip-12-peek-or-previous/
2 Replies

MVP
2023-06-29
03:00 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
There is a detailed explanation of the difference here
https://www.naturalsynergies.com/q-tip-12-peek-or-previous/

Contributor
2023-06-29
03:45 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you!!
1,032 Views
