topic Quantity does not match data in QlikView https://community.qlik.com/t5/QlikView/Quantity-does-not-match-data/m-p/691035#M250110 <HTML><HEAD></HEAD><BODY><P>If you look at the attached dashboard, you will see the sum for the date 01/05/2011 is 28 in the chart.</P><P></P><P>Yet looking at the raw data, this value should only be one.</P><P></P><P>I know this is something to do with how I have linked my sales transaction to the master calender, as removing this link corrects the chart.</P><P></P><P>I just can't see why.</P><P></P><P>What I am hoping to do is to use some calculations similar to below, to compare periods of time </P><P></P><P>&lt;Period = {"&lt;=$(=Max(Period))"}, Year = {"$(=Max(Year))"}, Quarter = , Month = &gt;</P><P></P><P>&lt;Period = {"&lt;=$(=Max(Period))"}, Year = {"$(=Max(Year)-1)"}, Quarter = , Month = &gt;</P><P></P><P>I have to generate my Master Calender differently because the dates are linked to Accounting Periods.</P><P></P><P>Thanks</P><P></P><P>Andy</P></BODY></HTML> Thu, 09 Oct 2014 09:54:45 GMT 2014-10-09T09:54:45Z Quantity does not match data https://community.qlik.com/t5/QlikView/Quantity-does-not-match-data/m-p/691035#M250110 <HTML><HEAD></HEAD><BODY><P>If you look at the attached dashboard, you will see the sum for the date 01/05/2011 is 28 in the chart.</P><P></P><P>Yet looking at the raw data, this value should only be one.</P><P></P><P>I know this is something to do with how I have linked my sales transaction to the master calender, as removing this link corrects the chart.</P><P></P><P>I just can't see why.</P><P></P><P>What I am hoping to do is to use some calculations similar to below, to compare periods of time </P><P></P><P>&lt;Period = {"&lt;=$(=Max(Period))"}, Year = {"$(=Max(Year))"}, Quarter = , Month = &gt;</P><P></P><P>&lt;Period = {"&lt;=$(=Max(Period))"}, Year = {"$(=Max(Year)-1)"}, Quarter = , Month = &gt;</P><P></P><P>I have to generate my Master Calender differently because the dates are linked to Accounting Periods.</P><P></P><P>Thanks</P><P></P><P>Andy</P></BODY></HTML> Thu, 09 Oct 2014 09:54:45 GMT https://community.qlik.com/t5/QlikView/Quantity-does-not-match-data/m-p/691035#M250110 2014-10-09T09:54:45Z