Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to use two or more alternate state on a single listbox

hi

i am facing a problem  in which i have a single list box in three different charts.Out of two charts are based on two different  alternate states like stateA & stateB. and having one list box say plant field which is common for all three  charts

Now what i want, when i made a selection on list box it effects on all the charts

i m stuck off this problem.Please help me

Any solution from your side will be appreciable

Regards

vishwaranjan

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

You can change the expression in the charts to use the default state for selections in the plant field. Sum(Sales) would become: sum({<plant=$::plant>}Sales). The chart will still use its assigned alternate state for the other fields. Only for field plant is the default state used.

Another option is to add Select in Field actions to the OnSelect field trigger and specify the alternate state in which the action should be applied.


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

You can change the expression in the charts to use the default state for selections in the plant field. Sum(Sales) would become: sum({<plant=$::plant>}Sales). The chart will still use its assigned alternate state for the other fields. Only for field plant is the default state used.

Another option is to add Select in Field actions to the OnSelect field trigger and specify the alternate state in which the action should be applied.


talk is cheap, supply exceeds demand
Not applicable
Author

Do you mean, you don't want the selection to affect one of your chart? Use the set analysis for this. For example, you dont want the state selection to affect the calculation in one of the chart, you need to use the below

sum({<State=>} Revenue)

Does this help you?

Not applicable
Author

hi sir

brilliant sir 

could you please tell me the working of scope resolution here, i never ever used it before

Thanks a lot for your help.

Regards

vishwaranjan