Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
reivax31
Partner - Creator III
Partner - Creator III

Display greyed out values in a table

Hi Qlikers,

I'm trying to show in a table all the value of my dimension. In the filters this will represent the green, light grey and dark grey values. So I have 3 dimension in my table. City, Sport, Licence ID. In my table I will put dimension = Sport and count(Licence ID) so I know how many people I have registered for each sport. Then when I filter on a City my measure will adapt and that is fine. But also my dimension will adapt because for some cities in my data base I have no line for a specific sport. So I my table the sport isn't displayed, but I want to keep it visible for this time.

I saw sevaral subject about it using e() function but I didn't managed to make it work.

Thanks for your help

1 Reply
reivax31
Partner - Creator III
Partner - Creator III
Author

I think there is something to do like what there is in these post

Opposite Associations | Qlik Community

But I cannot manage to make it work