Discussion Board for collaboration related to QlikView App Development.
I want the variance between expense and forecast to be displayed in a guage .. when actuals is less than forecast want the needle to point to red
How can i get this working
yeah .. but when you select the months the variance is -4.1 which is in green , and for march its red(9%) can we do same in guage chart? .. red and green are based on Actual < Forecast = Green , else red
You have to use these conditions in your Segment Lower Bounds. try from your end?
=If((Sum(Amount)-Sum(ForecastAmount))/sum(Amount) < 0.4, Green(), If((Sum(Amount)-Sum(ForecastAmount))/sum(Amount) <0.9, Red(), Yellow()))
Sure, Here you go some play around the settings
Note - Please mark helpful and Flag correct answer if you got solution. That may offer you in details