Manipulate SQL Stored Proc. column on Qlikview scripting

[ksomosera10]

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!

[tresesco · Accepted solution]

You could possibly try using preceding load like:

Load

          If( Active=1, Active) as Timelogs ;

<Your sql procedure facing command here>

[ksomosera10]

Are you saying like this?

Load

          If( Active=1, Active) as Timelogs ;

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

[tresesco]

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

[ksomosera10]

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

[tresesco]

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]

Thanks it works!