Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Peek clarification

Hi Guys,

I could find that below logic is used in one dashboard script, but can not find 'Export_LastStatusChange', Could you please help me understand this logic?what it does?

if (Previous ([stat])=[Index du statut], Peek ('Export_LastStatusChange_Date'),Date(Period_Date)))  AS Export_LastStatusChange_Date,

5 Replies
Chanty4u
MVP
MVP

peek(Export_LastStatusChange_Date)


is your  New columnNme

Chanty4u
MVP
MVP

try with simple example

Data:

LOAD * INLINE [

ID, Value

1, 1

2, 2

3, 3

];

CONCATENATE (Data)

LOAD 4 as ID,

peek('Value') as Value

AUTOGENERATE 1

;

exit SCRIPT;

sunny_talwar

Where are you seeing this?

Export_LastStatusChange

Do you may be mean Export_LastStatusChange_Date?

Anonymous
Not applicable
Author

its getting loaded in this script, but no peek table or column

LOAD *,

ApplyMap('NillInvoice',[ID de facture IP],null()) AS Nill,

    AutoNumberHash256([ID de facture IP]) AS Facture_id,

  text(if (Previous ([ID de facture IP])<>[ID de facture IP], [Index du statut],

    if (Previous ([Index du statut])=[Index du statut], Peek ('Export_Histo_Status'),

    Peek ('Export_Histo_Status') &'->'& [Index du statut]))) AS Export_Histo_Status,

  if (Previous ([ID de facture IP])<>[ID de facture IP], Date(Period_Date),

    if (Previous ([Index du statut])=[Index du statut], Peek ('Export_LastStatusChange_Date'),Date(Period_Date))) AS Export_LastStatusChange_Date,

 

    if(Previous([ID de facture IP])<>[ID de facture IP],date(Max_Approval_Date),

  if(isnull(Max_Approval_Date),Peek('Export_Max_Approval_Date'),date(Max_Approval_Date))) AS Export_Max_Approval_Date 

  Resident EXP_QUERY_QVD_ALL

sunny_talwar

its getting loaded in this script, but no peek table or column

What do you mean by this? no peek table or column? I don't think I understand