How to display actuals till current month and budget for future months in qlikview bar chart?

[anilet123]

Hi ,

I have a requirement to display actuals and budget for all months in a selected year, in which i have always one value selected in Year and Month fields. For eg , if March is selected, Jan , Feb & Mar should display actuals whereas Apr to Dec should display budget numbers. Can anyone pls help on this?

Attaching dummy data for the same

Regards,

Anilet Nirmal

[anilet123]

Hi Vineeth,

Thanks you so much for giving such a wonderful solution. I missed the equals to sign while creating the variable and used $(vMonth) in my actual expression. Now corrected both and your solution works perfect. Thanks again.

Regards,

Anilet Nirmal

[anilet123]

Hi qliksus,

This solution also worked but how do I change the background color using this expression ?

Thanks

Anilet Nirmal

[qliksus]

Hi Nirmal,

The same color expression should work

=if( only({1}DATE(DATE_SKEY))<=4, LightCyan() ,LightMagenta())

and your chart expression is what I stated above