Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

ZoeM
Contributor II

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

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 II

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.

Highlighted
ZoeM
Contributor II

Re: Arrow Object appearing based on Dimension Selection