issue with Straight table when setting up background color

Tue, 11 Dec 2012 12:52:08 GMT

Hello Friends,

I am facing some issue with Straight table when setting up background color.

i am using the same expression which is used for bar chart for setting the background color. Its working fine with Bar chart( I think its because of the Dimension is

"Month" .

When i use this expression for Straight table, it is displaying the same background color for all the field values. I am not sure, what exactly the problem is?

Expression:

=if (Sum ({$<Year={$(#=Only(Year))}>} [P1 - Complaints]) < (Only(If(Ref='P1',RAGGreen)/100) * Sum ({$<Year={$(#=Only(Year)-1)}>} [P1 - Complaints])),RGB(69,234,21),if (Sum ({$<Year={$(#=Only(Year))}>} [P1 - Complaints]) <= Sum ({$<Year={$(#=Only(Year)-1)}>} [P1 - Complaints]), RGB(255,128,0), RGB(255,0,0)) )

Where 'Ref' and 'RAGGreen' are columns from RAG table.

For P1- Complaints, Ref='P1' and RAGGreen=90.

iam comparing the current year compaints with 90% of Previous years complaints in the expression.

The columns in the Straight Table are displayed horizontally.

Regards

Siva

Re: issue with Straight table when setting up background color

bi4usupport — Tue, 11 Dec 2012 14:30:45 GMT

Hello sivadandu,

with the Pivot-table you cummulate the values according to the dimension Year.

So You have to use Aggr-function:

aggr(

if (Sum ({$<Jahr={$(=(Jahr))}>}Complaints ) < ( 90/100 * Sum ( {$<Jahr={$(=Jahr-1)}>} Complaints)),RGB(69,234,21),

if (Sum ({$<Jahr={$(=(Jahr))}>} Complaints) <= Sum ({$<Jahr={$(=Jahr-1)}>} Complaints), RGB(255,128,0), RGB(255,0,0) ))

,Monat)

Good Luck

topic Re: issue with Straight table when setting up background color in QlikView

issue with Straight table when setting up background color

Re: issue with Straight table when setting up background color