Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Solution

Accepted Solutions
tresesco
MVP
MVP

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

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

View solution in original post

3 Replies
mightyqlikers
Creator III
Creator III

Hi,

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

then chart will reflect as per the selections

Regards

Samwise

tresesco
MVP
MVP

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

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

View solution in original post

Not applicable
Author

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