1 Reply Latest reply: Jan 18, 2017 9:22 AM by xavier hemelaar RSS

    Display greyed out values in a table

    xavier hemelaar

      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