Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
ZoeM
Contributor II

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

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

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 II

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?