Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Author

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
Anonymous
Not applicable
Author

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
Not applicable
Author

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)

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)
Anonymous
Not applicable
Author

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
Author

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

Something like this

Anonymous
Not applicable
Author

In Presentation tab check suppress null values?

neelamsaroha157
Specialist II
Specialist II

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

Anonymous
Not applicable
Author

Thanks Oleg.. Your data island suggestion worked..