Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
kavitha_kommise
Partner
Partner

Not getting values as per the selection

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

 

 

 

 

1 Solution

Accepted Solutions
kavitha_kommise
Partner
Partner
Author

its working fine.

 

thanks for everyone,

kavitha

View solution in original post

7 Replies
thiago_justen

Try this out (with double quotes):

 

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

 

Cheers

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
shiveshsingh
Master
Master

Can you try this?

 

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

kavitha_kommise
Partner
Partner
Author

No difference, same thing

Nothing has changed.

thiago_justen

Are you able to share a mock up?

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
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
Master
Master

Can you check the format for your DATE field?

kavitha_kommise
Partner
Partner
Author

its working fine.

 

thanks for everyone,

kavitha

View solution in original post