topic Re: Point in time in Loading Script in QlikView

Point in time in Loading Script

razvan_brais — Mon, 05 Feb 2018 14:28:11 GMT

Hey guys,

Hope you can help me with this problem.

I want to create a table in which I have values for current day and for previous day.

The script looks something like :

NoConcatenate

temp:

LOAD

if(match(kpiNo,15,16,17,18,19,20,21),Value01*(-1),Value01) as Value1,

DATE,

Name_Kpi,

kpiNo;

LOAD sum(Value) as Value01,

date( floor( DATE ))as DATE,

Name_Kpi,

kpiNo

Resident BS

Group By DATE,

Name_Kpi,

kpiNo;

drop Table BS;

NoConcatenate

tmpBS:

LOAD

Value1 as Value,

DATE,

Name_Kpi,

kpiNo,

'CD' as PointInTimeVersion

Resident temp;

Concatenate(tmpBS)

LOAD

if(Name_Kpi =Previous(Name_Kpi), Previous(Value1),0) as Value,

DATE,

Name_Kpi,

kpiNo,

'PD' as PointInTimeVersion

Resident temp

Order by kpiNo,DATE;

drop Table temp;

But the problem is that for Previous Day I`m getting same values as for current day. Can you please help me? Or if you know another way to calculate Previous Day in Loading Script please tell me.

Thanks,

Razvan

Re: Point in time in Loading Script

Anil_Babu_Samineni — Mon, 05 Feb 2018 14:59:45 GMT

May be this?

if(Name_Kpi =Previous(Name_Kpi), Alt(Peek('Value'),0) as Value

Re: Point in time in Loading Script

razvan_brais — Tue, 06 Feb 2018 05:55:33 GMT

I have tried with Peek() function , but , after reload , I`m not getting any value. It brings blank values. Do you know what the problem might be?

Thank you

Re: Point in time in Loading Script

razvan_brais — Tue, 06 Feb 2018 07:39:42 GMT

What I have noticed , is that when I use Previous(Value) , I get only for a few kpi`s the previous value , and the rest of the kpi`s , keeps the current value.

Re: Point in time in Loading Script

razvan_brais — Wed, 07 Feb 2018 07:24:57 GMT

Hello there.

I solved the problem. The script was ok with Previous() function , but it was a problem of ordering column.