topic Re: Peek clarification in QlikView

Peek clarification

Anonymous — Tue, 12 Jun 2018 10:43:15 GMT

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,

Re: Peek clarification

Chanty4u — Tue, 12 Jun 2018 11:00:17 GMT

peek(Export_LastStatusChange_Date)

is your New columnNme

Re: Peek clarification

Chanty4u — Tue, 12 Jun 2018 11:05:53 GMT

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;

Re: Peek clarification

sunny_talwar — Tue, 12 Jun 2018 11:28:29 GMT

Where are you seeing this?

Export_LastStatusChange

Do you may be mean Export_LastStatusChange_Date?

Re: Peek clarification

Anonymous — Tue, 12 Jun 2018 11:45:59 GMT

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

Re: Peek clarification

sunny_talwar — Tue, 12 Jun 2018 11:50:59 GMT

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