Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Background color depending on another results


Hi,

I need to use a formula that changes the background of the cell depending on the result of the expression (i am coparing between the Forecast and the budget).

If the forecast is >= Budget then green else red. But this doesn't work for me.

Can you help me to correct this expression.

Please find attached my application.

Thanks

3 Replies
Not applicable

Re: Background color depending on another results

Hello Imen,

In your background color expression:

sum({ <YEAR_EXERCISE ={"= $(v_SelectedYear)"},SPQVC_ORDER={'V01'},EXERCISE ={'BUDGET'}>} Amount)

Returns 0 for every value that is not associated with EXERCISE = 'BUDGET'.

So I replaced the above with your v_Budget, which is equal to 21,579,268.37.

The problem with this is that it is greater than every single one of your act/fcst.

This might be something you can fix in your load script. The problem is that your other Exercises cannot be compared to your Budget Exercises.

Not applicable

Re: Background color depending on another results

Hi Jacob,

Thanks for your response 


In fact i have to compare month by month the budget and the froecast. In the table tht i am using you can see in the bottom the value of the budget ... i have to compare it with the value of the 1st forecast month and if it is greater than red else green.

A fixed value (a sum of all the budget) is not what i am looking for in my expression.

Do you have any suggestion?

Thanks

Not applicable

Re: Background color depending on another results

Budget:

Load

EXERCISE as Budget

where EXERCISE like 'BUDGET';

If you put this in your load script underneath the PCnL tab, you could use this new Budget field to make comparisons maybe.

Community Browser