I need some help to figure out the best way to convert a stored procedure to qlik sense.
Here is an example of the script I need to have in qlik.
SELECT GPxxxxx.Buyxxxxx,SUM(isnull(GPxxxxx.GrossProzzz,0)) as GrossProzzz
INTO #GP FROM GPxxxxx WITH(NOLOCK) INNER JOIN Buyxxxxx WITH(NOLOCK) ON GPxxxxx.Buyxxxxx = BuySell.Buyxxxxx AND GPxxxxx.Source <> 'B' and Exists(SELECT Buyxxxxx FROM WksDyyyyyyy INNER JOIN GLAccount WITH(NOLOCK) ON GLAccount.GLAcct = WksDyyyyyyy.GLAcct WHERE GLAccount.Cat <> 'COMM EXPENSE' AND WksDyyyyyyy.Buyxxxxx = Buysell.Buyxxxxx) WHERE (InvoiceDtqqq >= @FromDt and InvoiceDtqqq <= @ToDt) AND BuySell.[STATUS] = 'I' AND BuySell.TotalWeightLbs <> 0 AND (@Dept = '' OR Buysell.COIIIID = @Dept ) AND (@TradeType = '' OR Buysell.TradeType = @TradeType ) AND (@SalesRep = '' OR (@SalesRep = BuySell.Referrer222 OR @SalesRep = BuySell.ReferrerNo2)) GROUP BY GPxxxxx.Buyxxxxx
