Function in Script

Thu, 29 Apr 2010 14:44:50 GMT

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

Function in Script

Oleg_Troyansky — Thu, 29 Apr 2010 14:49:51 GMT

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,

Function in Script

Fri, 30 Apr 2010 08:53:16 GMT

Thank you very much 🙂

topic Function in Script in QlikView

Function in Script

Function in Script

Function in Script