Skip to main content
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
ashokunbi
Contributor III
Contributor III

Exclude Selected Filter Value from Chart

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.

4 Replies
dplr-rn
Partner - Master III
Partner - Master III

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

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
Partner - Master III
Partner - Master III

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

ashokunbi
Contributor III
Contributor III
Author

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))