15 Replies Latest reply: May 24, 2012 12:33 PM by kemcco25 RSS

    Group data on a bar chart to create an 'Others' category

      HI all.


      I'm a newbie on the Qlikview World, so I really need your help


      I've been looking on the forums and I can't found an exact answer to my problem.

      I have a bar chart and a dimension called "Values". When I selected items from "Values", they appears on the chart. My problem is that besides the selected data I need to add a new one called 'Others', that contains the summatory of the non selected data.


      I found that expression


      if(dimensionality(),sum({<product =e(product)>}sale),sum(sale))


      With this, the selected values are not shown on the chart, only the non selected (great, I need this), but I don't know how to combine to obtain the selected data and the 'Others' in the same chart


      Thanks a lot