topic Re: Error in Let statement in QlikView

Error in Let statement

Anonymous — Wed, 04 Nov 2015 08:04:15 GMT

What is error in following statement?

let VMaxTrxnDate=max(TRXDATE);

Re: Error in Let statement

avinashelite — Wed, 04 Nov 2015 08:07:08 GMT

check whether TRXDATE is in DATE or Number format ?

Re: Error in Let statement

Anonymous — Wed, 04 Nov 2015 08:08:35 GMT

if TRXDATE is a column/field of a table this is not possible

you may build a temporary table to get the max(TRXDATE) and then

assign to a variable using peek function

LET VMaxTrxnDate=peek('yournewfield',x) x 0 or -1 depends on order of your temp table

Re: Error in Let statement

jonathandienst — Wed, 04 Nov 2015 08:14:32 GMT

Let evaluates the expression and this expression cannot be evaluated at load time. Perhaps you want to use this in the front end. Change the let to set:

set VMaxTrxnDate = max(TRXDATE);

set VMaxTrxnDate = '=max(TRXDATE)';

Now you can use VMaxTrxnDate in front end expressions.

Re: Error in Let statement

Anonymous — Wed, 04 Nov 2015 08:16:17 GMT

So you mean to say if I assign any field value directly to Let variable, it will never work?

Through Peek() I need to assign, if not Temp table?

Re: Error in Let statement

Anonymous — Wed, 04 Nov 2015 08:17:30 GMT

Avinash ,Format is not a concern...

Re: Error in Let statement

Anonymous — Wed, 04 Nov 2015 08:26:16 GMT

I have a similiar Problem where I Need to get Dates out of a fact table and Loop through them

i use

Timetab:
NoConcatenate load Distinct
MyDate
Resident Timetab1
order by 1 asc;

in a Loop i use this statement

LET vNoRows = noofrows('Timetab'); // number of months

for i= 0 to vNoRows //
Let vDate = peek(MyDate,i,'Timetab');

Re: Error in Let statement

Anonymous — Wed, 04 Nov 2015 08:29:53 GMT

Thats Fine.

What I am looking for is:

Is their any alternate way to fetch the maximum date entry value without taking resident of it?

Re: Error in Let statement

Anonymous — Wed, 04 Nov 2015 08:36:48 GMT

Not to my knowledge

That's why I use the peek function

Re: Error in Let statement

Anonymous — Wed, 04 Nov 2015 08:38:19 GMT

Oky, But again to do it with Peek() I need to go for resident load which I dont want...

Re: Error in Let statement

Anonymous — Wed, 04 Nov 2015 08:43:44 GMT

if you find another way, it will be great

if not, you need to eat a sour apple (you may drop the resident table), the result is more important if it's the

only way to achieve what you want

Re: Error in Let statement

jagan — Wed, 04 Nov 2015 08:45:14 GMT

Hi Balraj,

You cannot directly use Aggregare functions in LET statement instead you can try like below

MaxTRXDATE:

Load

Max(TRXDATE) AS MaxDate

RESIDENT Invoice;

let VMaxTrxnDate=Peek('MaxDate');

DROP TABLE MaxTRXDATE;

Hope this helps you.

Regards,

Jagan.

Re: Error in Let statement

Anonymous — Wed, 04 Nov 2015 09:48:26 GMT

I want to use at backend only.

But no problem as shared by other, will do.