Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

sanjyotpatkar
Contributor III

values in the legend not disappearing as per selection

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?

1 Solution

Accepted Solutions
Not applicable

Re: values in the legend not disappearing as per selection

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

Something like this

View solution in original post

8 Replies
sitrakiniaina_j
Contributor II

Re: values in the legend not disappearing as per selection

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?

sanjyotpatkar
Contributor III

Re: values in the legend not disappearing as per selection

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

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)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
sanjyotpatkar
Contributor III

Re: values in the legend not disappearing as per selection

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

Not applicable

Re: values in the legend not disappearing as per selection

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

Something like this

View solution in original post

sitrakiniaina_j
Contributor II

Re: values in the legend not disappearing as per selection

In Presentation tab check suppress null values?

neelamsaroha157
Valued Contributor II

Re: values in the legend not disappearing as per selection

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

sanjyotpatkar
Contributor III

Re: values in the legend not disappearing as per selection

Thanks Oleg.. Your data island suggestion worked..