topic Targets and date dimension in QlikView https://community.qlik.com/t5/QlikView/Targets-and-date-dimension/m-p/830303#M1012165 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>I'm hoping to get some tips on the best way to utilize targets in qlikview. I have a standard data model loaded into a document, with two date dimensions based on sale order date and invoice date. I have targets for each month for different customer types. I have joined this to the invoice date dimension table. This joins on invoice date, and target date value is always tenth of the month because this is a safe day where the value will always be in that calander month's financial month (1st of month can fall into previous month's financial month) </P><P></P><P>What is the best way to link my customer grouping to a monthly target? Linking in the method above means that if no billing took place on that given day in for that customer group in the fact table, then the target does not pull through. I cant join on a month-year value because this would duplicate my target values by the matching number of fields in the date dimension (I'm assuming that would happen as it happens in SQL obviously)</P><P><IMG alt="Qlikview target linkage.png" class="jive-image image-1" src="/legacyfs/online/85108_Qlikview target linkage.png" style="height: auto;" /></P></BODY></HTML> Mon, 27 Apr 2015 10:34:58 GMT 2015-04-27T10:34:58Z Targets and date dimension https://community.qlik.com/t5/QlikView/Targets-and-date-dimension/m-p/830303#M1012165 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>I'm hoping to get some tips on the best way to utilize targets in qlikview. I have a standard data model loaded into a document, with two date dimensions based on sale order date and invoice date. I have targets for each month for different customer types. I have joined this to the invoice date dimension table. This joins on invoice date, and target date value is always tenth of the month because this is a safe day where the value will always be in that calander month's financial month (1st of month can fall into previous month's financial month) </P><P></P><P>What is the best way to link my customer grouping to a monthly target? Linking in the method above means that if no billing took place on that given day in for that customer group in the fact table, then the target does not pull through. I cant join on a month-year value because this would duplicate my target values by the matching number of fields in the date dimension (I'm assuming that would happen as it happens in SQL obviously)</P><P><IMG alt="Qlikview target linkage.png" class="jive-image image-1" src="/legacyfs/online/85108_Qlikview target linkage.png" style="height: auto;" /></P></BODY></HTML> Mon, 27 Apr 2015 10:34:58 GMT https://community.qlik.com/t5/QlikView/Targets-and-date-dimension/m-p/830303#M1012165 2015-04-27T10:34:58Z Re: Targets and date dimension https://community.qlik.com/t5/QlikView/Targets-and-date-dimension/m-p/830304#M1012166 <HTML><HEAD></HEAD><BODY><P>Should I be linking to customer table?</P></BODY></HTML> Mon, 27 Apr 2015 13:16:13 GMT https://community.qlik.com/t5/QlikView/Targets-and-date-dimension/m-p/830304#M1012166 2015-04-27T13:16:13Z Re: Targets and date dimension https://community.qlik.com/t5/QlikView/Targets-and-date-dimension/m-p/830305#M1012167 <HTML><HEAD></HEAD><BODY><P>Slim pickings on here today, huh?</P></BODY></HTML> Mon, 27 Apr 2015 14:00:06 GMT https://community.qlik.com/t5/QlikView/Targets-and-date-dimension/m-p/830305#M1012167 2015-04-27T14:00:06Z