Problem in chart using alternate states

Mon, 27 May 2013 11:40:05 GMT

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...............

Re: Problem in chart using alternate states

Gysbert_Wassenaar — Mon, 27 May 2013 11:43:17 GMT

The expressions use the default state for Category: ,Category=$::Category. So the listbox you use to select sea food should also be assigned to the default state if you want the selections to be applied to your expressions.

Re: Problem in chart using alternate states

Mon, 27 May 2013 13:46:39 GMT

Thank you Gysbert it works exactly

topic Re: Problem in chart using alternate states in QlikView

Problem in chart using alternate states

Re: Problem in chart using alternate states

Re: Problem in chart using alternate states