values in the legend not disappearing as per selection

[Anonymous]

Attaches is my qvw file. I have application and month in my dimension. when i select the value in the application the graph updates the correct values but the legend is remaining static..is there a way to do this? when i put aggr(Application,Application) in the dimension then few months are skipped from the X axis.

I have used a canonical calendar in this to generate 12 months trend. i need to show missing months with the line touching zero where there are nil values.

Can anybody please share few suggestions on how to go about it?

[Anonymous]

I don't know if i understood clearly your needs but if i'm not wrong, you want to always display all 12 months in you x axis ?

Did i you try to put only Last12Months instead of you conditional dimension?

[Anonymous]

yes..I need only 12 months data so I have put Last12Months in it.

Even i put months and now Last12Months and I put Application in the dimension even after I select specific values in the application the legend values of non selected applications do not disappear

[Anil_Babu_Samineni]

May be use? Here, This condition won't change if you select or trying to filter

count(distinct {1<DateType={'Created','Created_RTC','Created_Regulatory_Static_2016'},[Referred to CPS]={'Y'},

Revised_Priority = {'1. High','2.1 Medium - Multiple Customer Impact','2.2 Medium - Critical care Customer Impact','1.1 Critical','1.2 Critical','2.1 High','2.2 High','1. Critical','2. High','3.1 Medium - Urgent'}>}

[TR #])+sum({1<Month = {"$(='>=' & Min(Month) & '<=' & Max(Month))"},Application=>} 0)

[Anonymous]

if I is put in count then by default it shows all application.. i need the application lines to change based on the user selection

[#6 · Accepted solution]

Try to use Data Island with Last 12 months. Add field from island as dimension.

Something like this

[Anonymous]

In Presentation tab check suppress null values?

[neelamsaroha157]

It is because your expression is using set analysis where you are overriding the 'Application' field selection.

[Anonymous]

Thanks Oleg.. Your data island suggestion worked..