topic Using different dimensions for aggregating in one table in QlikView https://community.qlik.com/t5/QlikView/Using-different-dimensions-for-aggregating-in-one-table/m-p/628997#M1093270 <HTML><HEAD></HEAD><BODY><P>If you look at the attached excel file I have start dates and end dates on first sheet. Using this I am creating the count of all members that were active on the 15th of each month. </P><P></P><P>At the same time I have premium data in another table which I am aggregating by month. This is simply sum of premium and dimension is monthname(Policy Date). This policy date is different from the date coming on the data in the first sheet. </P><P></P><P>I want to create a table which will show number of members active on Jan 15 in first column and then total premium for Jan in second column. </P><P></P><P>Would appreciate any idea / help in this regards. </P></BODY></HTML> Sun, 11 May 2014 08:19:11 GMT 2014-05-11T08:19:11Z Using different dimensions for aggregating in one table https://community.qlik.com/t5/QlikView/Using-different-dimensions-for-aggregating-in-one-table/m-p/628997#M1093270 <HTML><HEAD></HEAD><BODY><P>If you look at the attached excel file I have start dates and end dates on first sheet. Using this I am creating the count of all members that were active on the 15th of each month. </P><P></P><P>At the same time I have premium data in another table which I am aggregating by month. This is simply sum of premium and dimension is monthname(Policy Date). This policy date is different from the date coming on the data in the first sheet. </P><P></P><P>I want to create a table which will show number of members active on Jan 15 in first column and then total premium for Jan in second column. </P><P></P><P>Would appreciate any idea / help in this regards. </P></BODY></HTML> Sun, 11 May 2014 08:19:11 GMT https://community.qlik.com/t5/QlikView/Using-different-dimensions-for-aggregating-in-one-table/m-p/628997#M1093270 2014-05-11T08:19:11Z Re: Using different dimensions for aggregating in one table https://community.qlik.com/t5/QlikView/Using-different-dimensions-for-aggregating-in-one-table/m-p/628998#M1093271 <HTML><HEAD></HEAD><BODY><P>just an idea in the attachment</P></BODY></HTML> Sun, 11 May 2014 10:56:18 GMT https://community.qlik.com/t5/QlikView/Using-different-dimensions-for-aggregating-in-one-table/m-p/628998#M1093271 maxgro 2014-05-11T10:56:18Z