Function in Script

[#1]

Hello,

I have to create a QVD with a result of an function SQL:

In Microsoft SQL Server the function is :

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
CREATE FUNCTION <Inline_Function_Name, sysname, FunctionName>
(
-- Add the parameters for the function here
<@param1, sysname, @p1> <Data_Type_For_Param1, , int>,
<@param2, sysname, @p2> <Data_Type_For_Param2, , char>
)
RETURNS TABLE
AS
RETURN
(
-- Add the SELECT statement with parameter references here
SELECT 0
)
GO)

How I can create a QVD with this?

Can you help me please?

Kind Regards

[Oleg_Troyansky · Accepted solution]

If I understand correctly, you just need to use your SELECT statement in QlikView and use the $ sign expansion functionality to pass any values as parameters. For example:

SQL SELECT * FROM SALES WHERE DATE >= $(MyCalculatedDateVariable)

cheers,

[#3]

Thank you very much 🙂