Selection Indicators in Pivot Table

[shannoypaul]

In a pivot table I want to indicate the reduction in number of orders for a particular Ice Cream.

[richard_pearce6]

Hi,

You could use the background formatting option in expression to show the day on day change

Create a formula:

if( Sum({<Sales) - Sum({1<[%Date] = {$(Exp_Prev_Date)}> Sales)

> 0
RGB(255,0,0) // Red
,RGB(0,255,0)// Green
)

If you can post your data model on here if you need help with the second expression (Previous Day). Depending on your structure that may need a bit more work.

Richard

qlikcentral.com

[shannoypaul]

Week is a field name and I have done cross tab to put it horizontally!

In the first week 96 in the next week 0, since there is a reduction 0 is highlighted.

Sorry, I miised week reported column in the original post.

[richard_pearce6]

Try adding the expression

sum(Sales) - before(sum(Sales))

[richard_pearce6 · Accepted solution]

Here is my working example.

As you have dimensions across the top this works, if you had dimensions on the left the above() function would do the job.

Richard

QlikCentral.com

[richard_pearce6]

Did this answer your question Shannoy?

[shannoypaul]

Yes, Thank You very much!