topic Re: Manipulate SQL Stored Proc. column on Qlikview scripting in QlikView

Manipulate SQL Stored Proc. column on Qlikview scripting

ksomosera10 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Everyone,

I need your help.

I have this Qlikview script to call SQL Stored procedure:

SQL EXEC [dbo].[usp_TimeLogs] '7/1/2017','7/31/2017'

Inside this contains columns like:

Active - which consists of '0' for not active and '1' for active

Timelogs - Duration of People

I need to manipulate columns or create another table from the generated by SQL Stored Procedure.

How can I do that on Qlikview script?

For example:

If Active == 1 then Timelogs

Else NULL

Thanks in advance!

tresB — Tue, 08 Aug 2017 07:42:42 GMT

You could possibly try using preceding load like:

Load

If( Active=1, Active) as Timelogs ;

ksomosera10 — Tue, 08 Aug 2017 07:46:08 GMT

Are you saying like this?

Load

If( Active=1, Active) as Timelogs ;

SQL EXEC [dbo].[usp_TimeLogs] '7/1/2017','7/31/2017'

tresB — Tue, 08 Aug 2017 07:49:28 GMT

If the procedure execution alone gives the data in qlik, that should work.

ksomosera10 — Tue, 08 Aug 2017 07:51:16 GMT

Yup It works! but I only got the 'Timelogs' column after the load.

tresB — Tue, 08 Aug 2017 09:04:48 GMT

You have to include the other fields in load explicitly or '*' for all, like:

Load

If( Active=1, Active) as Timelogs ;

SQL EXEC [dbo].[usp_TimeLogs] '7/1/2017','7/31/2017

ksomosera10 — Wed, 09 Aug 2017 00:33:04 GMT

Thanks it works!