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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2017-12-07 02:04 AM

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])

360 Views
0 Likes
0 Replies