Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

How do I use filter in inherited state in calculation of expression of chart with different alternate state?

I am having a date filter in inherited state and I want to use that in calculation of MAT expression of bar and line chart having different alternate state. I am not able to see any change in chart upon filter selection. Following is my expression used in chart having different alternate state . "NDate" is the filter in inherited state.

Ndate is in month-year format

Currently filter selection doesnt impact my charts.

I want my charts to be populated according to the date selected in filter.

=Sum({<NDate ={">=$(=Date(addmonths(Max(NDate), -11),'MM/YYYY')) <=$(=Date(addmonths(Max(NDate), -0),'MM/YYYY'))"} >} [Sales])