Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
limingthefirst
Contributor III
Contributor III

aggr condition in bar chart

Hi,

I have a issue in bar chart using aggr function when calculate the no. of vendors for each part and company_site

The dimension is:

=if(aggr(Count(DISTINCT Vendor_Code), Part_Code,Company_Site)=1,

'1 Vendor',

aggr(Count(DISTINCT Vendor_Code), Part_Code,Company_Site)&' Vendors')

And the expression is:

Count(DISTINCT Part_Code)

So the bar chart is below, and link to category detail table. Now the Company Site and Part Number column is not selected

1.png

The issue is when click the 2 Vendors in bar chart, 1 Vendor has appeared. Normally, this should not appear.

2.png

Owing to the third record, Company Site and Part Number has only one Vendor.

The first and second record is what I want when I click the bar chart.

Can anybody help me to fix this issue? Thanks.

1 Solution

Accepted Solutions
sunny_talwar

Create a new field in the script using this

LOAD AutoNumber(Part_Code&Company_Site) as Key,


and then try this as your dimension

=If(Aggr(Count(DISTINCT Vendor_Code), Key) = 1, '1 Vendor', Aggr(Count(DISTINCT Vendor_Code), Key)&' Vendors')

View solution in original post

5 Replies
sunny_talwar

Create a new field in the script using this

LOAD AutoNumber(Part_Code&Company_Site) as Key,


and then try this as your dimension

=If(Aggr(Count(DISTINCT Vendor_Code), Key) = 1, '1 Vendor', Aggr(Count(DISTINCT Vendor_Code), Key)&' Vendors')

limingthefirst
Contributor III
Contributor III
Author

Thank Sunny, the Part_Code and Company_Site is in different table, I will try to modify the data model.

sunny_talwar

It might be possible without changing the data model, but it will have to be tested, would you be able to share a sample?

limingthefirst
Contributor III
Contributor III
Author

I have create a demo.qvw, but the issue is it appear 3 Vendors when click the 1 Vendor

limingthefirst
Contributor III
Contributor III
Author

I have change the data model, and it working well, Thank you again.