2 Replies Latest reply: May 27, 2013 9:46 AM by Amuthabharathi Subramanian RSS

    Problem in chart using alternate states

      Hi QV experts,

       

        I have a chart which shows sales by region. I use  products as two groups Group1 and Group2. I display both the groups in a list boxes i use the following expression in charts to show the sales

       

       

      Group1:

      SUM({[Group 1]

      <Year=$::Year

      ,Month=$::Month

      ,Day=$::Day

      ,Quarter=$::Quarter

      ,Category=$::Category

      ,Region=$::Region

      ,Customers=$::Customers

      ,Suppliers=$::Suppliers

      ,Shippers=$::Shippers

      ,Employees=$::Employees

      ,Products=$::Products

      >}

      NetPrice)

       

       

      Group2:

      SUM({[Group 2]

      <Year=$::Year

      ,Month=$::Month

      ,Day=$::Day

      ,Quarter=$::Quarter

      ,Category=$::Category

      ,Region=$::Region

      ,Customers=$::Customers

      ,Suppliers=$::Suppliers

      ,Shippers=$::Shippers

      ,Employees=$::Employees

      ,Products=$::Products

      >}

      NetPrice)

       

      The above expression working well and my chart reflect all the selections i made in groups or filters.But my requirement is when i made a selection in filter the changes reflect only in charts not in groups. For example if i select the sea food in the category filter then the group1 and group2 must enable/show only  the products coming under the sea food category . I dont know how to reflect the changes in the listboxes for group1 and group2. Can any one help me how to get this...............