topic Re: Data being displayed using background colour in expession. in QlikView

Data being displayed using background colour in expession.

Tue, 24 May 2011 08:46:56 GMT

Data being displayed using background colour in expession.

raghavsurya — Tue, 24 May 2011 09:01:30 GMT

can u pls elaborate your question

Data being displayed using background colour in expession.

Tue, 24 May 2011 09:03:16 GMT

Sorry

Will post correctly

I have a Table similar to below

Type Objective Value

A 2 3

B 2 1

C 1 1

TOTAL 2 1.66

The value column contains a calculated percentage. The objective total is displayed using Max Of Rows.

I have set the background colour in the expression to be

if(sum(Value) <= sum(Obective), green(), red()).

The if statement sees the Total Objective as 5 rather than the the displayed value. It is possible for it to look at the dispalyed value rather than the sum?

Data being displayed using background colour in expession.

raghavsurya — Tue, 24 May 2011 09:09:48 GMT

Hi,

Try using RangeMax functionality.

if(Sum(Value)<=RangeMax(Objective),Green(),Red().

Regards,

Raghav

Re: Data being displayed using background colour in expession.

kaushiknsolanki — Tue, 24 May 2011 09:16:34 GMT

As per my understanding of your problem i am here by sending you an example

Regards,

Kaushik Solanki

Re: Data being displayed using background colour in expession.

Tue, 24 May 2011 10:24:23 GMT

This does quite work but I may have not been clear initially. I hae re attachd the document highlighting what is happening.

The total is a calculated expression and the objective total displays the MAX value of that column. The value column is showing in Blue because it is less than the sum of the objective which is 7. However I want to look at the displayed value of 2 so it shows in red.

Apprieciate your help so far.

Re: Data being displayed using background colour in expession.

Tue, 24 May 2011 10:27:16 GMT

I have posted the example again with RangeMax and it does the same as before.

Thanks

Data being displayed using background colour in expession.

raghavsurya — Tue, 24 May 2011 10:33:35 GMT

Hi,

Use Only Max instead of Rangemax. Its working for me.

Regards,

Raghav

Re: Data being displayed using background colour in expession.

Tue, 24 May 2011 10:53:58 GMT

Thank You

It works in the demo doc but still does not quite work in mine. I will see if I am missing something.

Re: Data being displayed using background colour in expession.

montubhardwaj — Tue, 24 May 2011 10:55:51 GMT

HI,

Please find the attached file.Hope this is helpful. I have made few chanegs in the attached by Kaushik.

Regards,

Sharma