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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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.