Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
ZoeM
Contributor III

Concatenate Arrow Object with Expression value

Hello community.

I have a pivot chart with one dimension and several expressions. My dimension is year and I am using it as a column to compare years across the different expressions. 

The user would like to compare the years (more than one) and have arrows go either up or down depending on the value.

I would like the arrows to start when more than one year is selected and starts with the year in the second column.

Here is a mock up of intended end result in excel:

Defaults.JPG

I have attached a sample dashboard with a simple pivot chart and one expression to hopefully see if it can work.

Thanks guys.

1 Solution

Accepted Solutions
Highlighted

Re: Concatenate Arrow Object with Expression value

Try this

If(ColumnNo() = 1, Sum([#of Days to Purchase]),
If(Sum([#of Days to Purchase]) < Before(Sum([#of Days to Purchase])), Sum([#of Days to Purchase])&chr(8595), Sum([#of Days to Purchase])&chr(8593)))
2 Replies
Highlighted

Re: Concatenate Arrow Object with Expression value

Try this

If(ColumnNo() = 1, Sum([#of Days to Purchase]),
If(Sum([#of Days to Purchase]) < Before(Sum([#of Days to Purchase])), Sum([#of Days to Purchase])&chr(8595), Sum([#of Days to Purchase])&chr(8593)))
ZoeM
Contributor III

Re: Concatenate Arrow Object with Expression value

Always awesome Sunny.

Can I take this one step further? Is it possible to have just the arrows be a specific color based on value? So if it is an increase then it is good and we want it to be green? 

How would I define that expression?