topic Re: values in the legend not disappearing as per selection in QlikView

values in the legend not disappearing as per selection

Anonymous — Thu, 13 Apr 2017 09:26:31 GMT

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?

Re: values in the legend not disappearing as per selection

Anonymous — Thu, 13 Apr 2017 10:15:47 GMT

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?

Re: values in the legend not disappearing as per selection

Anonymous — Thu, 13 Apr 2017 10:44:42 GMT

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

Re: values in the legend not disappearing as per selection

Anil_Babu_Samineni — Thu, 13 Apr 2017 10:53:27 GMT

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)

Re: values in the legend not disappearing as per selection

Anonymous — Thu, 13 Apr 2017 11:02:12 GMT

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

Re: values in the legend not disappearing as per selection

Thu, 13 Apr 2017 11:10:46 GMT

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

Something like this

Re: values in the legend not disappearing as per selection

Anonymous — Thu, 13 Apr 2017 14:34:17 GMT

In Presentation tab check suppress null values?

Re: values in the legend not disappearing as per selection

neelamsaroha157 — Thu, 13 Apr 2017 14:58:20 GMT

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

Re: values in the legend not disappearing as per selection

Anonymous — Fri, 21 Apr 2017 06:38:48 GMT

Thanks Oleg.. Your data island suggestion worked..