Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

If and Set Analysis in combo chart

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...

Community Browser