3 Replies Latest reply: May 19, 2011 4:06 AM by Dinesh Kumar RSS

    Question : Chosen value not affect other tables

      Hi All,

           Please refer to my attached image. I had built a data model and want to draft some charts.

      In the first chart, I didn't filter anything and the chart shows the meeting count of each staff with their respected sales amount in year of 2010 and 2011.

       

      Now, I would like to show the same chart with ALL STAFFS but only shown their Year 2011 Sales Amount. But after I put filter on sales amount, QlikView filtered out those staffs who do not have sales in 2011, which is not what I want.

      So, does anyone has any suggestion to achieve this?

       

      I tried to use SET ANALYSIS but seems like it does not allow multiple selections.

       

      Thanks