Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Check out our latest virtual session where BARC Fellow, Doug Laney, highlighted the opportunities data monetization can offer enterprises. Watch here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Unwanted Data in Sheet

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!

1 Reply
Colin-Albert
Partner - Champion
Partner - Champion

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.