topic Re: calculate Variable using Let in QlikView

calculate Variable using Let

poluvidyasagar — Sat, 16 Nov 2024 05:00:35 GMT

Hi,

I am trying to calculate a specific date field which consists of weeknumber, yearnumber, daynumber.

I am able to do this using a text box. However, i would like to calculate during the load and assign it to a variable.

Expression I want to calculate using load is:

=Concat(right(Year(Today()),2) &Week(Today())+4 &Num(WeekDay(Today())))

I am using LET to calculate the value. How do i assign to a variable.

I have attached the qvw file.

Thanks,

Vidya

Re: calculate Variable using Let

Janneke — Mon, 10 Dec 2018 14:33:00 GMT

Hi Vidya,

Instead of :

Let vDate= Concat(right(Year(Today()),2) &Week(Today())+4 &Num(WeekDay(Today())));

Try:

SET vDate="=Concat(right(Year(Today()),2) &Week(Today())+4 &Num(WeekDay(Today())))";

Works for me in your example for a text object with expression =vDate

Greetings, Janneke.

Re: calculate Variable using Let

Anil_Babu_Samineni — Mon, 10 Dec 2018 14:37:47 GMT

This works

Let vDate= '=Concat(right(Year(Today()),2) &Week(Today())+4 &Num(WeekDay(Today())))';

Re: calculate Variable using Let

poluvidyasagar — Mon, 10 Dec 2018 14:52:34 GMT

Thanks Janneke.

I am using this variable as a condition on one of my table. But it gives error.

Here is the code:

set vDate= Concat(right(Year(Today()),2) &Week(Today())+4 &Num(WeekDay(Today())));

Data:
LOAD [Part Number],
[Final UP],
CNFROM,
CNTO
FROM
Data.xlsx
(ooxml, embedded labels, table is Sheet1)
Where not match(CNFROM,'#N/A','0') and CNFROM < $(vDate);

I have attached the file. Can you please let me know what is wrong here?

Thanks,
Vidya

Re: calculate Variable using Let

sunny_talwar — Mon, 10 Dec 2018 14:55:52 GMT

May be you are looking for this

LET vDate = Right(Year(Today()),2) & Week(Today())+4 & Num(WeekDay(Today()))

Re: calculate Variable using Let

sunny_talwar — Mon, 10 Dec 2018 15:01:58 GMT

Try this

LET vDate = Right(Year(Today()),2) & Week(Today())+4 & Num(WeekDay(Today()));

Data:
LOAD [Part Number], 
     [Final UP], 
     CNFROM, 
     CNTO
FROM [Data (3).xlsx]
(ooxml, embedded labels, table is Sheet1)
Where not match(CNFROM,'#N/A','0') and CNFROM < $(vDate);

Re: calculate Variable using Let

poluvidyasagar — Mon, 10 Dec 2018 15:49:41 GMT

I keep getting the error during load.

Can you please check and let me know where is the mistake.

Thanks,
Vidya

Re: calculate Variable using Let

poluvidyasagar — Mon, 10 Dec 2018 15:53:45 GMT

I think i got it. Concat function is LET is causing the issue.

Thanks Everyone