topic Problem with master calendar in QlikView https://community.qlik.com/t5/QlikView/Problem-with-master-calendar/m-p/176588#M44546 <HTML><HEAD></HEAD><BODY><P>Good day,</P><P></P><P>I use a master calendar to link sales and invoice, but my "sum(...)" gives me too many (the number of days in month times more).</P><P></P><P>Why does my values are counted more than 1 time ?</P><P>How can I avoid that without creating a separate table for years and months ?</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">=sum(if(Sales_Year = Year and Sales_Month = Month, Sales_Value))</PRE><BR /><BR /> <P></P><P>I can't use "distinct" because sometimes, my sales have the same amount...</P></BODY></HTML> Fri, 04 Jun 2010 16:38:54 GMT 2010-06-04T16:38:54Z Problem with master calendar https://community.qlik.com/t5/QlikView/Problem-with-master-calendar/m-p/176588#M44546 <HTML><HEAD></HEAD><BODY><P>Good day,</P><P></P><P>I use a master calendar to link sales and invoice, but my "sum(...)" gives me too many (the number of days in month times more).</P><P></P><P>Why does my values are counted more than 1 time ?</P><P>How can I avoid that without creating a separate table for years and months ?</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">=sum(if(Sales_Year = Year and Sales_Month = Month, Sales_Value))</PRE><BR /><BR /> <P></P><P>I can't use "distinct" because sometimes, my sales have the same amount...</P></BODY></HTML> Fri, 04 Jun 2010 16:38:54 GMT https://community.qlik.com/t5/QlikView/Problem-with-master-calendar/m-p/176588#M44546 2010-06-04T16:38:54Z