Problem with Pie chart expression for Duplicate set of values

Wed, 25 Nov 2020 16:16:04 GMT

Hello Guys,

I encountered with a scenario where

IF the vendor number is different against the same vendor name than that is a duplicate vendor not when it displays against the same vendor number ;And if vendor name repeats one time with different vendor number than in pie chart it will display under the category 1 and if it repeats more one time than it will displayed as >1 Duplicate Vendor.

So, Final output for the given scenario have to be

Against 1 Duplicate record : 1

Against >1 Duplicate Record : 2

I am attaching the Excel here for this scenario and QVD .

Thanks is advance , any help is appreciated.

Re: Problem with Pie chart expression for Duplicate set of values

sunny_talwar — Mon, 03 Oct 2016 16:23:42 GMT

I think in your current scenario, all three Vendors are associated with multiple Vendor Numbers

But may be try like this

Dimension

=Aggr(If(Count(DISTINCT [Vendor Number]) = 1,1,0),[Vendor Name])

Expression

Count(DISTINCT [Vendor Name])

topic Problem with Pie chart expression for Duplicate set of values in QlikView

Problem with Pie chart expression for Duplicate set of values

Re: Problem with Pie chart expression for Duplicate set of values