topic Re: Exclude(E) function in QlikView

Exclude(E) function

jjking58 — Wed, 25 Nov 2020 16:16:04 GMT

Can someone tell me why this would not work?

I've researched this on the community site and everything looks correct, but i'm not getting any results in my table

Thanks in advance

sergio0592 — Thu, 13 Jul 2017 19:19:14 GMT

Try with :

sum( {$<fYear =,CustomerName= E({1<ProductName={‘BASEBALL PRO’}>})>} PartsAmt) +

sum( {$<fYear =,CustomerName= E({1<ProductName={‘BASEBALL PRO’}>})>} EqupAmt) +

sum( {$<fYear =,CustomerName= E({1<ProductName={‘BASEBALL PRO’}>})>} LaborAmt) +

vishsaggi — Thu, 13 Jul 2017 19:21:26 GMT

Try this:

= Rangesum(0, Sum({<fYear=, CustomerName = E({1< ProductName = {'BASEBALL PRO'}) >} PartsAmt),

Sum({<fYear=, CustomerName = E({1< ProductName = {'BASEBALL PRO'}) >} EqupAmt),

Sum({<fYear=, CustomerName = E({1< ProductName = {'BASEBALL PRO'}) >} LaborAmt)

)

sunny_talwar — Thu, 13 Jul 2017 19:23:09 GMT

You are missing closing >} within e()

jjking58 — Thu, 13 Jul 2017 19:35:28 GMT

I tried adding the closing >} and have the same results

jjking58 — Thu, 13 Jul 2017 20:25:28 GMT

I found the problem i changed sum({$ to sum({1 and the number appeared. I was excluding customers based on the current selection

Thanks both for the quick response