Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.