topic How to write the expression in QlikView

How to write the expression

kunkumnaveen — Wed, 15 Jan 2020 11:36:27 GMT

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

Re: How to write the expression

lironbaram — Wed, 15 Jan 2020 11:44:41 GMT

in order to ignore selection you need to use set analysis

sum({<yard>}sales)

Re: How to write the expression

kunkumnaveen — Wed, 15 Jan 2020 11:47:24 GMT

Will this work

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

According to my requirement I have to use aggr function also

Re: How to write the expression

Brett_Bleess — Wed, 12 Feb 2020 21:06:43 GMT

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