Both branches of your if statement are the same. And both branches have a closing parenthesis without a matching opening one. Your expression cannot work (unless your variable vMed contains an opening parenthesis).
I don't understand your problem. Perhaps you can post a small qlikview document that illustrates the problem.
Thanks for your reply.
Sorry did not mention formula correctly
Now the correct one is
and this is working.
The only reason is we are getting data from excel and it has already calulcations done and iam showing that data in chart without any aggregation using setanalysis.
The chart shouldnot change when specific month selection is done,It need to display the chart for whole year.
With this formulae its working fine however the bold format for dimension and back ground is not working due to "only" in caluclation level.
At the dimension level i have wrriten following for back ground colour
The earlier formulae where its working for back ground and text format is
=IF(AGGR='R',($(vMedida)),($(vMedida_SinRollup))) however its showing chart for specific month selection and we want to exclude month and show whole year without effecting month selection