Exclude Selected Filter Value from Chart

[ashokunbi]

I have a pie chart that displays data from vendors selected in a List Box which works fine. I need to add another pie chart that displays data from all the other vendors beside the selected vendor in the list box. The expressions will be the same save excluding the selected vendor. Any help will be appreciated.

[dplr-rn]

try using the e() expression within your setanalysis

something like

Sum({<CustomerRegion=E(CustomerRegion)>}LineSalesAmount) which excludes all selection of CustomerRegion dimension

check below

https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetA...

[ashokunbi]

Sorry I didn't get back to you sooner on this Dilip and BTW thanks for your help. I checked out the link and used your sample and I am getting no data to display.

Here is my original expression that shows the data for the selected vendor in the list box:

((sum($(vLTMPts))/Count(ItemNumber))*.20)+

((Count(if(ReceiptDate - PromisedDate <= 0,0))/Count(RequestedDate))*.3)+

(((count(DocNumber)-count(if(Issues>0,0)))/Count(DocNumber))*.05)+

(((Sum(QtyDamaged)/Sum(QtyRcvd)-1)*-1)*.10)+

(((($(vQ3AvgCost)-$(vQ2AvgCost))/$(vQ2AvgCost)*PVWeight)+(TermsWeight*Terms)+(RTWeight*Returns))*.05)+

(.90*.30)

And here is the modification I made based on your response:

(Sum({<VendorName=E(VendorName)>}((sum($(vLTMPts))/Count(ItemNumber))*.20)+

((Count(if(ReceiptDate - PromisedDate <= 0,0))/Count(RequestedDate))*.3)+

(((count(DocNumber)-count(if(Issues>0,0)))/Count(DocNumber))*.05)+

(((Sum(QtyDamaged)/Sum(QtyRcvd)-1)*-1)*.10)+

(((($(vQ3AvgCost)-$(vQ2AvgCost))/$(vQ2AvgCost)*PVWeight)+(TermsWeight*Terms)+(RTWeight*Returns))*.05)+

(.90*.30)) )

Like I said I am getting No Data To Display in the chart after the modification.

Thanks

[dplr-rn]

you will need to repeat the set analysis for all the aggregation functions

[ashokunbi]

I just tried below and it didn't work. Not sure if that is what you mean. 

(Sum({<VendorName=E(VendorName)>}((sum($(vLTMPts))/Count(ItemNumber))*.20))+

(Sum({<VendorName=E(VendorName)>}((Count(if(ReceiptDate - PromisedDate <= 0,0))/Count(RequestedDate))*.3))+

(Sum({<VendorName=E(VendorName)>}(((count(DocNumber)-count(if(Issues>0,0)))/Count(DocNumber))*.05))+

(Sum({<VendorName=E(VendorName)>}(((Sum(QtyDamaged)/Sum(QtyRcvd)-1)*-1)*.10))+

(Sum({<VendorName=E(VendorName)>}(((($(vQ3AvgCost)-$(vQ2AvgCost))/$(vQ2AvgCost)*PVWeight)+(TermsWeight*Terms)+(RTWeight*Returns))*.05))+

(Sum({<VendorName=E(VendorName)>}(.90*.30))