Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
brunolelli87
Creator II
Creator II

Change the bar colour if the date is not selected

Hey guys,

The following bar chart shows the number of flights per airline per day:

brunolelli87_0-1618502346203.png

And, I'm using the set analysis expression {<MY_DATE_FIELD=>}, in order to let the user to select a spcific date without changing the dimension. In this case, if the user select 08/04/21 for example, this is what he sees. Otherwise he would just see the bar corresponding to day 08/04/21.

brunolelli87_1-1618502473013.png

Which is really very nice, because the selected date is now in evidence.

My question is:
How can I change the colors of the NON SELECTED DATES? I would like to have the same color of the selected DATE but with a transparency. 

Thanks

11 Replies
tresesco
MVP
MVP

🙂

If(DASI=DASI, RGB(RRRR, GGGG, BBBB),Only({1}ARGB(70,RRRR, GGGG, BBBB))) 

brunolelli87
Creator II
Creator II
Author

Brilliant!!!!