Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

deniscamh
Contributor

Colors greyed out after selection

Hi all,

I created a bar chart with the years and categories as dimensions:

Action categories.JPG

My expression is: count({<Total_Period = {'Past Actions'},Year = {">= $(=Year(AddYears(Max([Action Date]),-5)))"}>} distinct [Action Import ID])

When I make a Year selection the colors for not selected years become grey but the data still showing:

Action Category2.JPG

What should I do to prevent colors become grey?

Thank

2 Replies
CarlosAMonroy
Contributor III

Re: Colors greyed out after selection

Hi Denis,

Maybe just add the year to the set analysis as a exclude selection field. Something like:

count({<Year=, Total_Period = {'Past Actions'},Year = {">= $(=Year(AddYears(Max([Action Date]),-5)))"}>} distinct [Action Import ID])


Hope that helps,

Carlos M

deniscamh
Contributor

Re: Colors greyed out after selection

Thanks Carlos,

I already tried it.

Does not work, same result.

Thanks

Community Browser