Inline Load from Variable Values

[mhmmd_srf]

Hi All,

This is in Qliksense.

I have a variable called vDATE, which is max date. I want to load max date and last 4 same weekdays.

I am giving code like:

Last4Weekday:

LOAD * INLINE

[

Last4Weekday

'$(vDATE)',

Date(Date#('$(vDATE)','M/D/YYYY') - 7)

];

vDATE is loading but last weekday is not loading.

Can anyone please help me on this?

Thanks,

Sarif

[hamzabob1]

Can you attach a sample qvw to look in more detail?

Regards'

hamza

[mhmmd_srf]

Actually I am working in Qliksense HUB. I can share the detail script with you.

LASTDT:

LOAD max(Z_DATE) as LASTDT

RESIDENT ORD_VOL;

LET vDATE = Date(Date#(Peek('LASTDT',0,'LASTDT'),'YYYYMMDD'),'M/D/YYYY');

Last4Weekday:

LOAD * INLINE

[

Last4Weekday

'$(vDATE)',

Date(Date#('$(vDATE)','M/D/YYYY') - 7)