topic Re: Concatenate Arrow Object with Expression value in QlikView

Concatenate Arrow Object with Expression value

ZoeM — Sat, 16 Nov 2024 03:25:30 GMT

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:

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

Thanks guys.

Re: Concatenate Arrow Object with Expression value

sunny_talwar — Thu, 30 May 2019 14:28:32 GMT

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)))

Re: Concatenate Arrow Object with Expression value

ZoeM — Thu, 30 May 2019 14:52:25 GMT

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?