topic Aggr and MissingValues question. in QlikView https://community.qlik.com/t5/QlikView/Aggr-and-MissingValues-question/m-p/418151#M487048 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I'm struggling to get missing values to the pivot table. I'm using Aggr() function to get the figures as the figures should be aggregated by the specific dimensions.</P><P>I'd like to see the total of all the members including those who doesn't have a record in sales table.</P><P>please see the test file attached.</P><P></P><P>Any ideas will help me a lot. thank you in advance.</P><P></P><P>Best Regards,</P><P>~Sergejs</P></BODY></HTML> Thu, 07 Mar 2013 12:52:19 GMT zekazak 2013-03-07T12:52:19Z Aggr and MissingValues question. https://community.qlik.com/t5/QlikView/Aggr-and-MissingValues-question/m-p/418151#M487048 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I'm struggling to get missing values to the pivot table. I'm using Aggr() function to get the figures as the figures should be aggregated by the specific dimensions.</P><P>I'd like to see the total of all the members including those who doesn't have a record in sales table.</P><P>please see the test file attached.</P><P></P><P>Any ideas will help me a lot. thank you in advance.</P><P></P><P>Best Regards,</P><P>~Sergejs</P></BODY></HTML> Thu, 07 Mar 2013 12:52:19 GMT https://community.qlik.com/t5/QlikView/Aggr-and-MissingValues-question/m-p/418151#M487048 zekazak 2013-03-07T12:52:19Z