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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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!

Labels (1)
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.