Arrow Object appearing based on Dimension Selection

[ZoeM]

Hello Community.

Hope you are all well today.

I have a Pivot Chart with year as the dimension and a count expression. 

When the user selects an two or more years, I would like to show an arrow next to the expression value based on the difference i.e. if user selects 2018 and 2019 I would like to have an arrow pointing downwards next to 2019 if the count is less or upwards if count is more. 

And if the user selects multiple years, I would like to show this for all subsequent years too. Is this possible?

Any help rendered will be truly appreciated!

Thanks

[bharathadde]

Try this

=if(Aggr(Sum(Totalsum),Year)<Above(Sale),'▼','▲') & ' ' & Aggr(Sum(Totalsum),Year)

[ZoeM]

Here is a sample QVW dashboard with a pivot chart that has Year and sum expression, I was not able to get your expression to work. 

[bharathadde]

We cannot do it on pivot, but we can do it on straight table. Please find the attachment.

[ZoeM · Accepted solution]

Here is a thread with the answer:

https://community.qlik.com/t5/QlikView-App-Development/Concatenate-Arrow-Object-with-Expression-valu...

Thanks so much!