Qlik Community

Qlik Sense Cloud Discussions

Highlighted
matthewlau120
New Contributor

Date and Month Filter are not Referring to the Same Number

When I use the [Order Date] to select the date, it can refer the accurate year to date figure for me. However, the figure is wrong when I use the month and year filter to refer same date. Can someone help me??

Tags (2)
3 Replies
Partner
Partner

Re: Date and Month Filter are not Referring to the Same Number

Share your expressions please

matthewlau120
New Contributor

Re: Date and Month Filter are not Referring to the Same Number

Here is my expression of Year To Date Formula:

Sum({$<[Order Date] = {">=$(=YearStart(Max([Order Date])))<=$(=Max([Order Date]))"}>} [Sales Volume])

Partner
Partner

Re: Date and Month Filter are not Referring to the Same Number

Ok you want the expression to ignore the month and year selection if i understand correctly. use below (replace month and year by your own fields)

Sum({$<Month=,Year=,[Order Date] = {">=$(=YearStart(Max([Order Date])))<=$(=Max([Order Date]))"}>} [Sales Volume])