Calender is not working

[Vinil]

Hi Team,

 I need to see the total price for the previous month(example:03/01/2020 to 03/31/2020) instead of that I am seeing different i:e  previous month's first day to one day before the last date of the previous month(example:03/01/2020 to 03/30/2020). This is happening for all the months. When I am checking for an individual date total purchases then that total is matching with my data set totals but when checking for month-wise it's not populating correctly.

Please take a look at the variables that I am using to display dates on the calendar.

Thanks in Advance.

Thanks,

Vinil

[Arthur_Fong]

You have a sample app?

[Vinil]

I couldn't share it here.

Thanks,

Vinil

[Vinil]

Please help me with that issue. Today, I saw that calendar is working for few months and showing the right data but not happening same for a few months.

Thanks in Advance.

Vinil

[Vinil]

=Sum({<[invoice date]={">=$(=date(admonths(v_start_date,0),'MM/DD/YYYY'))<=$(=date(v_end_Date,'MM/DD/YYYY'))"),[corp_acct_key]={1}>}Purchase dollar amnt])

This is my set analysis to get the sum of the selected months or year. But I am getting a different sum for the selected .month

example:03/01/2020 to 03/31/2020) instead of that I am seeing different i:e  previous month's first day to one day before the last date of the previous month(example:03/01/2020 to 03/30/2020). This is happening for all the months. When I am checking for an individual date total purchases then that total is matching with my data set totals but when checking for month-wise it's not populating correctly.

[Brett_Bleess]

Very difficult to troubleshoot without sample app/data, not likely going to be able to help without it in this case, so if you cannot post, you may have to use other means to get assistance.  Best I can offer otherwise is the following Design Blog posts:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

There are some other links in the posts, so be sure to check those too.

Regards,
Brett