Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
jjking58
New Contributor III

Exclude(E) function

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

QlikExcl.PNG

5 Replies
sergio0592
Valued Contributor II

Re: Exclude(E) function

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
Esteemed Contributor III

Re: Exclude(E) function

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)

                     )

Re: Exclude(E) function

You are missing closing >} within e()

jjking58
New Contributor III

Re: Exclude(E) function

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

QlikExcl.PNG

jjking58
New Contributor III

Re: Exclude(E) function

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