topic Re: how to assign 2 alternate states to one list box in QlikView

how to assign 2 alternate states to one list box

Mon, 23 Mar 2015 06:26:35 GMT

Dear Gurus,

I have created a chart with 1 Dimension(Month) and 2 expressions.

I have 2 alternate states StateA and StateB

In the above chart 1st expression is like sum({StateA}Sales) and 2nd expression is like sum({StateB}Sales)

Note: Chart is not assigned to any particular state.

Sales are being changed when I make the selections in StateA or StateB related list boxes.

Problem is: I have Month list box which is not assigned to any Alternate state. If I make any selections on Month list box , my chart is not filtered for selected months.

Is there any way I can assign 2 alternate states to this Month list box as Month is a common dimension in my chart for the above 2 expressions.

Please guide.

BR,

Chinna

Re: how to assign 2 alternate states to one list box

mightyqlikers — Mon, 23 Mar 2015 06:29:41 GMT

Hi,

create two list boxes for month field and assign alternate states one each.

then chart will reflect as per the selections

Regards

Samwise

Re: how to assign 2 alternate states to one list box

tresB — Mon, 23 Mar 2015 06:39:12 GMT

If you want the Default state's selection to be considered in your expression, try like:

sum({StateA} <Month=$::Month> Sales)

Re: how to assign 2 alternate states to one list box

Mon, 23 Mar 2015 07:59:19 GMT

Thank You Tresesco. This is what I was looking for..Many thanks