Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Not applicable

how to assign 2 alternate states to one list box


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

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

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

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

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

3 Replies
Highlighted
mightyqlikers
Contributor III

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

Hi,

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

then chart will reflect as per the selections

Regards

Samwise

MVP
MVP

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

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

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

Not applicable

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

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