topic Not getting values as per the selection in QlikView

Not getting values as per the selection

kavitha_kommise — Mon, 19 Nov 2018 10:49:34 GMT

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

Re: Not getting values as per the selection

Thiago_Justen_ — Mon, 19 Nov 2018 11:23:41 GMT

Try this out (with double quotes):

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

Cheers

Re: Not getting values as per the selection

shiveshsingh — Mon, 19 Nov 2018 11:11:23 GMT

Can you try this?

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

Re: Not getting values as per the selection

kavitha_kommise — Mon, 19 Nov 2018 11:43:03 GMT

No difference, same thing

Nothing has changed.

Re: Not getting values as per the selection

Thiago_Justen_ — Mon, 19 Nov 2018 11:45:39 GMT

Are you able to share a mock up?

Re: Not getting values as per the selection

sunny_talwar — Mon, 19 Nov 2018 12:10:13 GMT

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

Re: Not getting values as per the selection

shiveshsingh — Mon, 19 Nov 2018 12:09:45 GMT

Can you check the format for your DATE field?

Re: Not getting values as per the selection

kavitha_kommise — Tue, 20 Nov 2018 04:25:04 GMT

its working fine.

thanks for everyone,

kavitha