topic Multiple date dimensions in QlikView https://community.qlik.com/t5/QlikView/Multiple-date-dimensions/m-p/241483#M91897 <HTML><HEAD></HEAD><BODY><P></P><DIV id="Normalcontent" style="clear: both; color: #000000; direction: ltr; font-size: 9pt; margin-left: 12px; padding: 0px 3px; position: relative">Hello,<BR /><BR />I have a situation where I am stuck for now:<BR /><BR />I have product units that are loaded every month (one year data).<BR /><BR />Of these units I am upoading a file that the loaders give of delayed units with a delay date column.<BR /><BR /><BR /><BR />I want a metric (not perfect but best I can do) of no of delayed units as a 5 of total units loaded.<BR /><BR />the loaded date and delayed date are distinct dimensions though since a unit delayed in Dec 10 can be loaded in Jan 11.<BR /><BR />The key is the unit number itself and I have made the join on it.<BR /><BR /><BR /><BR />Any help appreciated.<BR /><BR />Kiran<BR /></DIV></BODY></HTML> Tue, 08 Mar 2011 07:49:53 GMT 2011-03-08T07:49:53Z Multiple date dimensions https://community.qlik.com/t5/QlikView/Multiple-date-dimensions/m-p/241483#M91897 <HTML><HEAD></HEAD><BODY><P></P><DIV id="Normalcontent" style="clear: both; color: #000000; direction: ltr; font-size: 9pt; margin-left: 12px; padding: 0px 3px; position: relative">Hello,<BR /><BR />I have a situation where I am stuck for now:<BR /><BR />I have product units that are loaded every month (one year data).<BR /><BR />Of these units I am upoading a file that the loaders give of delayed units with a delay date column.<BR /><BR /><BR /><BR />I want a metric (not perfect but best I can do) of no of delayed units as a 5 of total units loaded.<BR /><BR />the loaded date and delayed date are distinct dimensions though since a unit delayed in Dec 10 can be loaded in Jan 11.<BR /><BR />The key is the unit number itself and I have made the join on it.<BR /><BR /><BR /><BR />Any help appreciated.<BR /><BR />Kiran<BR /></DIV></BODY></HTML> Tue, 08 Mar 2011 07:49:53 GMT https://community.qlik.com/t5/QlikView/Multiple-date-dimensions/m-p/241483#M91897 2011-03-08T07:49:53Z