Not getting values as per the selection

[kavitha_kommise]

hello,

I am trying to find current month results irrespective of any selection using set expression..that is giving me proper results.but if i select any particular month from calendar where ever Month has 31 days there also i am getting fro 30 days aggregation only. how to fix these issue.is there any other way to show?

Currently i am using set using below set expression

Sum({1<DATE={'>=$(=v_cur_month_start_day)<=$(v_cur_month_end_day)'}>}[sales])

v_cur_month_start_day=monthstart(max(date))

v_cur_month_end_day=monthend(max(date))

dates are coming properly based on month selection

but aggregation iam getting for 30 days

please helpe me on same to solve issue.

Thanks in advance,

kavitha

[Thiago_Justen_]

Try this out (with double quotes):

Sum({1<DATE={">=$(=v_cur_month_start_day)<=$(=v_cur_month_end_day)"}>}[sales])

Cheers

[shiveshsingh]

Can you try this?

Sum({<DATE={">=$(=v_cur_month_start_day)<=$(=v_cur_month_end_day)"}>}[sales])

[kavitha_kommise]

No difference, same thing

Nothing has changed.

[Thiago_Justen_]

Are you able to share a mock up?

[sunny_talwar]

QlikView/Qlik Sense are case sensitive... Is your date called date or DATE? Make sure you use it consistently. Also, is your date field just a date or is it a timestamp? 

I suggest something like this

Variables

v_cur_month_start_day = MonthStart(Max(DATE))
v_cur_month_end_day = MonthStart(Max(DATE), 1)

Expression

Sum({1<DATE = {">=$(=v_cur_month_start_day)<$(=v_cur_month_end_day)"}>} [sales])

[shiveshsingh]

Can you check the format for your DATE field?

[kavitha_kommise · Accepted solution]

its working fine.

thanks for everyone,

kavitha