Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Not applicable

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.

Highlighted
Not applicable

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

Highlighted
Not applicable

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.