If and Set Analysis in combo chart

Sat, 29 Dec 2012 11:29:03 GMT

My If Condition and Set analysis is not giving me correct result.

Scenario:

I have a Combo chart with Actual Current year, Actual Previous Year and Budget Currect Year with Month dimension. Also I have selection in year and month.

i would like to show, if user select Year then chart will show (This is done) but when I am selecting month it is applying the filter condition on Month in chart, but i don;t want that. I want that If user is selecting Month then chart will show for entire month (Jan,Feb,mar,Apr...) data in chart,

My Calculation is:

If (Banca = 'Total Bank', SUM ({$<Month=, Code {1,2,3,4,5,6}>} Acutal_Amount),
if (Banca = 'Sector Bank', Sum ({$<Month=, Code {1,2,3,4,5,6,7,8,9,}>} Acutal_Amount),
if(Banca = getfieldselection(Banca), Sum ({$<Month=>} Acutal_Amount)
)))

by using the above calculation filter is applying in month. but I do not want that. Is there any way to restrict this thing rather then Different State.

Please help...

topic If and Set Analysis in combo chart in QlikView

If and Set Analysis in combo chart