topic Calender is not working in QlikView

Calender is not working

Vinil — Wed, 15 Apr 2020 22:15:50 GMT

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

Re: Calender is not working

Arthur_Fong — Thu, 16 Apr 2020 02:33:04 GMT

You have a sample app?

Re: Calender is not working

Vinil — Thu, 16 Apr 2020 03:12:47 GMT

I couldn't share it here.

Thanks,

Vinil

Re: Calender is not working

Vinil — Fri, 17 Apr 2020 02:19:07 GMT

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

Re: Calender is not working

Vinil — Mon, 20 Apr 2020 18:25:32 GMT

=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.

Re: Calender is not working

Brett_Bleess — Thu, 14 May 2020 14:29:43 GMT

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