get possible values from the field selection

[udaya_kumar]

Hi,

I have data something like as shown below (it's a sample data)

Plan	Month	ID	Value
Standard	May-16	1	10
Standard	May-16	2	20
Variable	May-16	3	30
Variable	May-16	4	40
Variable	May-16	5	50
Variable	May-16	6	60
Standard	Jun-16	1	10
Standard	Jun-16	2	20
Variable	Jun-16	3	30
Variable	Jun-16	4	40
Standard	Jun-16	5	50
Standard	Jun-16	6	60
Standard	Jul-16	1	10
Standard	Jul-16	2	20
Variable	Jul-16	3	30
Variable	Jul-16	5	40
Variable	Jul-16	8	50
Variable	Jul-16	9	60

I have to show the count of id's in bar chart with alternate states in the expression (Two alternate states and Two expressions).

I have two listbox with Month field (one with alternate state 'State1' and another with alternate state 'State2').

When i make selection in 'State1' Month listbox, then the bars (Expression 1) in chart should show the count of id's for Standard and Variable for the selected month, for ex. May 2016 (Month listbox with State1 alternate state).

When i make selection in 'State2' Month listbox, then the bars (Expression 2) in chart should show the count of id's for Standard and Variable for the selected month, for ex. Jun 2016 (Month listbox with State2 alternate state) but those id's which are present in May 2016, only those id's should be counted in expression 2 (Jun 2016) and other non-matched id's should show as others in the chart.

How to achieve this functionality in the chart?

[sunny_talwar]

Would you be able to share your sample qvw file?

[udaya_kumar]

Hi,

PFA.

[sunny_talwar · Accepted solution]

Can you check if this meets your requirement

[udaya_kumar]

Thanks for the information Sunny.

Is it possible to get the others count in selection group 2 itself, instead of keeping it as a separate expression?

[sunny_talwar]

Stack it you mean?