Converting SQL to Qlik

[Vern2022]

Hi all,

How do you do this in Qlik?

where [%QuoteSavedCalendarDateID] >= (SELECT TOP 1 [datefrom] from SalesFunnel_DateParams);
AND [%QuoteSavedCalendarDateID] <= (SELECT TOP 1 dateto FROM SalesFunnel_DateParams);

I cant find an answer anywhere. Many thanks.

[Kushal_Chawda]

@Vern2022  look at the interval match

https://help.qlik.com/en-US/sense/February2023/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPref...