Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
Valued Contributor II

Re: To combine Alternate State along with current selections in a chart

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

aaroncouran
Contributor III

Re: To combine Alternate State along with current selections in a chart

I think something like this:

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

Hope that helps,

Aaron

Community Browser