Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

To combine Alternate State along with current selections in a chart

In a dashboard, in one object (Bar Chart), i need to see sales trend against customers for all years. For other Information in the dashboard Current Selection - 2012, is required.

For this i added alternate state (All Years) for that chart only.

Current Selection is - 2012.

After above settings the chart shows yearly sales trend for all customers for all years.

The issue is after this setting when i am selecting specified customer (within the dashboard), it is not impacting the chart, and it is still showing data for all customers all years. Though i need to see yearly trend for selected customers for all years.

Is there any other way that current selections along with alternate state selections can depict results in a chart?

Thanks

Shiv Sharma

QV Issue 1.jpg

2 Replies
chematos
Specialist II
Specialist II

May be you can upload your file or copy your expressions and an image of your model to see how do you have the relation with the calendar

Anonymous
Not applicable
Author

I think something like this:

SUM({Group1<Year=$::Year>}Sales)    

Hope that helps,

Aaron