topic Exclude Selected Filter Value from Chart in QlikView

Exclude Selected Filter Value from Chart

ashokunbi — Wed, 10 Oct 2018 16:34:54 GMT

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.

Re: Exclude Selected Filter Value from Chart

dplr-rn — Wed, 10 Oct 2018 17:20:30 GMT

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/SetAnalysis/set-modifier…

Re: Exclude Selected Filter Value from Chart

ashokunbi — Thu, 11 Oct 2018 19:27:57 GMT

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

Re: Exclude Selected Filter Value from Chart

dplr-rn — Thu, 11 Oct 2018 20:13:21 GMT

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

Re: Exclude Selected Filter Value from Chart

ashokunbi — Thu, 11 Oct 2018 20:21:27 GMT

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