5 Replies Latest reply: Sep 30, 2010 4:38 AM by FKausler RSS

    Hide null values in trellis


      Hi All,

      I built a chart that graphically represents a pareto view of sales by customer. This works fine for single charts but breaks up in trellis, as the sorting of customers is done on overall numbers and not by the trelli's dimension.

      In this example it means, that in all trellis, the first customer is the one that has the most sales in europe, not in the specific country. If a customer bought in one country but not in another, this creates a blank bar. This behaviour is probably intended by QlikTech, but not usefull in my case.

      Also the aggregation doesn't work, but I found here, that this can be solved through manual aggregation so I believe I can fix this part myself.

      I'd appreciate it very much if anyone had an idea how to solve this.