topic Re: get possible values from the field selection in QlikView

get possible values from the field selection

udaya_kumar — Tue, 16 Aug 2016 12:27:58 GMT

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?

Re: get possible values from the field selection

sunny_talwar — Tue, 16 Aug 2016 12:38:57 GMT

Would you be able to share your sample qvw file?

Re: get possible values from the field selection

udaya_kumar — Tue, 16 Aug 2016 12:50:00 GMT

Hi,

PFA.

Re: get possible values from the field selection

sunny_talwar — Tue, 16 Aug 2016 12:58:28 GMT

Can you check if this meets your requirement

Re: get possible values from the field selection

udaya_kumar — Wed, 17 Aug 2016 07:22:38 GMT

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?

Re: get possible values from the field selection

sunny_talwar — Wed, 17 Aug 2016 07:23:55 GMT

Stack it you mean?