variable in the where clause not working in the qlikview script.

ashmitp869 — Wed, 09 Mar 2022 06:13:31 GMT

Hi there,

Please help me out with the below script -

let vDayPrev = 31;

TMP:
LOAD
MAX([Date]) as MaxDate
FROM [$(vL.QVDPath)\QVD \File.qvd]
(qvd);
let vMD_ToC = Num(Peek('MaxDate', 0, 'TMP'));

[ToC]:
LOAD
MakeDate(Year([ Date]),Month([Date]),Day([ Date])) as [ReportingDate],
[Identifier],
count(1) as count_toc
from
[$(vL.QVDPath)\QVD \File.qvd]
(qvd)
WHERE
[Date] >= '$(vMD_ToC)'-$(vDayPrev) AND [ Date] <= '$(vMD_ToC)'
group by [ Identifier],[Date];

What is wrong with the script . Please suggest .

My req , I want Maxdate - 31 days in the where condition i.e

WHERE
[Date] >= '$(vMD_ToC)'-$(vDayPrev) AND [ Date] <= '$(vMD_ToC)'

Thanks

Re: variable in the where clause not working in the qlikview script.

hic — Wed, 09 Mar 2022 08:53:47 GMT

Since I cannot see your data, I cannot tell for sure... but I would try a Where-clause like this instead:

WHERE
[Date] >= $(#vMD_ToC)-$(#vDayPrev) AND [Date] <= $(#vMD_ToC)

Also, you have an error in several places in the script: [Date] is not the same as [ Date]. You cannot have an extra space inside the quotes. What's inside the quotes must be exactly the same as the field name.

topic variable in the where clause not working in the qlikview script. in QlikView

variable in the where clause not working in the qlikview script.

Re: variable in the where clause not working in the qlikview script.