Unwanted Data in Sheet

Fri, 06 Nov 2015 14:16:04 GMT

In my sheet it is pulling in 3 accounts that we do not want to be calculated in our data. I have tried edited the script to get rid of these accounts but have been unsuccessful. I thought it should look similar to this:

SQL EXEC [dbo].[QVLedgerAllSp] @acct_start='50010', @acct_end='57119', @date_start='12/31/2013', @date_end='12/31/2015';

SQL EXEC [dbo].[QVLedgerAllSp] @acct_start='57122', @acct_end='57122', @date_start='12/31/2013', @date_end='12/31/2015';

SQL EXEC [dbo].[QVLedgerAllSp] @acct_start='57124', @acct_end='59999', @date_start='12/31/2013', @date_end='12/31/2015';

but that did not work. Any ideas on how I can get rid of these 3 accounts? Thank you in advance!

Re: Unwanted Data in Sheet

Colin-Albert — Fri, 06 Nov 2015 15:06:57 GMT

What result do you get in SQL if you run these three queries?

This looks more like a question for the developer of your stored procedure rather than a QlikView issue.

topic Unwanted Data in Sheet in QlikView

Unwanted Data in Sheet

Re: Unwanted Data in Sheet