topic Re: Arrow Object appearing based on Dimension Selection in QlikView

Arrow Object appearing based on Dimension Selection

ZoeM — Sat, 16 Nov 2024 03:26:00 GMT

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

Re: Arrow Object appearing based on Dimension Selection

bharathadde — Wed, 29 May 2019 21:08:57 GMT

Try this

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

Re: Arrow Object appearing based on Dimension Selection

ZoeM — Thu, 30 May 2019 13:04:03 GMT

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.

Re: Arrow Object appearing based on Dimension Selection

bharathadde — Thu, 30 May 2019 14:44:52 GMT

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

Re: Arrow Object appearing based on Dimension Selection

ZoeM — Thu, 30 May 2019 14:59:34 GMT

Here is a thread with the answer:

https://community.qlik.com/t5/QlikView-App-Development/Concatenate-Arrow-Object-with-Expression-value/m-p/1586704/highlight/false#M443262

Thanks so much!