Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
ZoeM
Contributor III

Arrow Object appearing based on Dimension Selection

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?

Defaults.JPG

Any help rendered will be truly appreciated!

Thanks

Labels (3)
1 Solution

Accepted Solutions
ZoeM
Contributor III

Re: Arrow Object appearing based on Dimension Selection

4 Replies
bharathadde
Contributor II

Re: Arrow Object appearing based on Dimension Selection

Try this

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

ZoeM
Contributor III

Re: Arrow Object appearing based on Dimension Selection

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
Contributor II

Re: Arrow Object appearing based on Dimension Selection

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

ZoeM
Contributor III

Re: Arrow Object appearing based on Dimension Selection