Chart Expression - Ignore Date Filter

[ashleycasper]

Hello -

I am using a Combo chart to show Total Staff Need over time. My app requires a date selection, so I would like to Ignore the Date field in this Combo Chart. I was able to ignore the Date field selection for all expressions in the chart except for the "Total Staff Need" trend line outlined in red below.

My expression for "Total Staff Need" is .. 

(((Sum([Task_Count] * [Standard AHT])/.69)/[Working Mins])
+ 3
+ (((Sum([Task_Count] * [Standard AHT])/.69)/[Working Mins]) * [Supervisor Ratio]))

How can I apply Set Analysis on above? The Date field I would like to ignore is called [Month/Year]. Thank you!

[NadiaB]

Hi @ashleycasper 

Please refer to the following documentation:

https://help.qlik.com/en-US/sense/February2021/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAn...

Ignore selection:

[Month/Year]=

Kind Regards.