How to write the expression

[kunkumnaveen]

Hello All,

In a  Bar chart 

Dimension : Year,Yard,

Expression : aggr(sum(sales),Yard)

So if any value from field yard is selected , then the chart should ignore the selection  and if any other fields are selected then chart should change

[lironbaram]

hi 

in order to ignore selection you need to use set analysis 

sum({<yard>}sales)

[kunkumnaveen]

Hi

Will this work

aggr(sum({<yard>}sales),yard)

According to my requirement I have to use aggr function also 

[Brett_Bleess]

Better if I point you to someone that knows what they are doing versus me trying to explain! 🙂

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

Here is the base URL for the Design Blog area too, there are 700+ posts in this area by our internal experts and most are how-to related, so prove to be helpful to you going forward.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett