Incorrect data displayed at Dashboard level

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am facing one issue in which whenever i was accessing the last 12 month data in my dashboard then i am getting the result for 13 month data.

My calculation is based on as below:

1) I am calculating the month start date by using the below expression:

Monthstart(Date(Selling_Date, 'DD/MM/YYYY'))

This is giving me date as 1st of month

2) I use the calculated dimension to get the 12 month data :

Date(Addmonths((Selling_Date,-12),'DD/MM/YYYY')

This issue is happening only in 1st of every month, if my system date has been change to 2nd till 30th of the month i am getting the data for last 12 months only.

Could you please advise.

Regards,

Rohit

Re: Incorrect data displayed at Dashboard level

ahaahaaha — Fri, 02 Jun 2017 14:04:13 GMT

Hi Rohit,

Maybe this is because you add 12 month to the original month? When the system date is shifted to another number, the one utmost month simply leaves the calculation.

If the calculation goes in the opposite direction with a minus sign, then it may be to try the interval from Date(Addmonths(CalDate,-1),'DD/MM/YYYY') to Date(Addmonths(CalDate,-12),'DD/MM/YYYY')?

Regards,

Andrey

topic Incorrect data displayed at Dashboard level in QlikView

Incorrect data displayed at Dashboard level

Re: Incorrect data displayed at Dashboard level