topic Re: Selection Indicators in Pivot Table in QlikView

Selection Indicators in Pivot Table

shannoypaul — Tue, 15 Apr 2014 11:53:05 GMT

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

Re: Selection Indicators in Pivot Table

richard_pearce6 — Tue, 15 Apr 2014 12:00:28 GMT

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

Re: Selection Indicators in Pivot Table

shannoypaul — Tue, 15 Apr 2014 12:35:42 GMT

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.

Re: Selection Indicators in Pivot Table

richard_pearce6 — Tue, 15 Apr 2014 13:17:34 GMT

Try adding the expression

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

Re: Re: Selection Indicators in Pivot Table

richard_pearce6 — Tue, 15 Apr 2014 13:19:50 GMT

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

Re: Selection Indicators in Pivot Table

richard_pearce6 — Tue, 15 Apr 2014 14:05:14 GMT

Did this answer your question Shannoy?

Re: Selection Indicators in Pivot Table

shannoypaul — Tue, 15 Apr 2014 14:37:15 GMT

Yes, Thank You very much!