topic Re: Variable in QlikView

Variable

qlikview979 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

Here my variable is not working .any one explain me why its not working.

T1:

LOAD ID,

PRODUCT,

SALES,

DATE

FROM

[.............................................................xlsx]

(ooxml, embedded labels, table is Sheet1);

LET Vpeek1=peek('DATE',-1,'T1');

Re: Variable

Kushal_Chawda — Wed, 18 May 2016 07:12:21 GMT

I do not see any problem. What do you want in Variable?

Re: Variable

Anonymous — Wed, 18 May 2016 07:12:33 GMT

Is your data sorted as per Date? What value is the variable returning?

Re: Variable

Chanty4u — Wed, 18 May 2016 07:13:51 GMT

its correct syntax only.

Peek() or Previous() ?

Re: Variable

kkkumar82 — Wed, 18 May 2016 07:13:55 GMT

Hi Mahesh,

Can you attach your qvw file with some sample data

Re: Variable

qlikview979 — Wed, 18 May 2016 07:21:26 GMT

Hi all,

please find the attached fine.

I am learning incremental load . i am using peek function for max date.

Re: Variable

Chanty4u — Wed, 18 May 2016 07:22:40 GMT

hi ,

chk below threads for Inc load

Incremental Load in Qlikview - Sources

Re: Variable

qlikview979 — Wed, 18 May 2016 07:22:57 GMT

Hi Kushal,

I want Max Date from date field.

Regards,

Mahesh.

Re: Variable

tresB — Wed, 18 May 2016 07:25:48 GMT

Try like:

T1:

LOAD ID,

PRODUCT,

SALES,

DATE

FROM

[.............................................................xlsx]

(ooxml, embedded labels, table is Sheet1);

Temp:

Load

max(DATE) as MaxDate

Resident T1;

LET Vpeek1=peek('MaxDate');

Drop Table Temp;

Re: Variable

kkkumar82 — Wed, 18 May 2016 07:32:06 GMT

Mahesh , if you are looking for Incremental load then Tresco way is the correct or your may also Order by the data by Date field (provided if the dates are numeric) then you can use Peek to get the max value.

Re: Variable

Kushal_Chawda — Wed, 18 May 2016 07:37:38 GMT

Hi Mahesh,

You need to first sort the Data

T1:

LOAD ID,

PRODUCT,

SALES,

DATE

FROM

[.............................................................xlsx]

(ooxml, embedded labels, table is Sheet1);

T2:

LOAD *

Resident T1

order by DATE ASC;

drop table T1;

LET Vpeek1=peek('DATE',-1,'T2');

Re: Variable

kkkumar82 — Wed, 18 May 2016 07:40:50 GMT

Please find attached,

1. Using Order by

2. Using Max(Date)

Re: Variable

qlikview979 — Wed, 18 May 2016 07:47:42 GMT

Hi Kushal,

Superb, Its working .

Regards,

Mahesh.

Re: Variable

qlikview979 — Wed, 18 May 2016 07:48:43 GMT

Hi Kumar,

I got it,thanks for support.

Regards,

Mahesh.

Re: Variable

qlikview979 — Wed, 18 May 2016 07:57:54 GMT

Hi Kushal,

Here I have one Doubt my DATE fields are ascending order right

DATE

5/1/2016

5/2/2016

5/3/2016

5/4/2016

5/5/2016

Why should we write ascending order in script.

Can you Explain me once.

Rehards,

Mahesh.

Re: Variable

Kushal_Chawda — Wed, 18 May 2016 08:34:54 GMT

You can do the ascending or descending based on your need. Here as per the variable used peek function in -1 indicates last record of the Data i.e Date .. So we did order bye ascending to pick Max Date. But if you need both Min and Max then You should take resident and Use min(Date) and max(Date)

Re: Variable

qlikview979 — Wed, 18 May 2016 08:39:13 GMT

Hi Kushal,

Got it, Thanks

Regards,

Mahesh