topic Calculated dimension with count expression and text in QlikView https://community.qlik.com/t5/QlikView/Calculated-dimension-with-count-expression-and-text/m-p/323771#M119308 <HTML><HEAD></HEAD><BODY><P>Thank you...Works perfectly!</P></BODY></HTML> Mon, 27 Jun 2011 11:08:05 GMT 2011-06-27T11:08:05Z Calculated dimension with count expression and text https://community.qlik.com/t5/QlikView/Calculated-dimension-with-count-expression-and-text/m-p/323769#M119306 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am trying to create a Calculated dimension, which concatenates a text field(Secondary theme), with the expression : count(distinct ........ )</P><P>I have attached the example I am working on.</P><P></P><P>I would like the Final Calculated dimension to have the Secondary Theme concatenated with COUNT(distinct&nbsp; [Unique Question]) , in brackets.</P><P></P><P>Any ideas would be greatly appreciated!</P><P></P><P>Thanks.<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 27 Jun 2011 10:49:07 GMT https://community.qlik.com/t5/QlikView/Calculated-dimension-with-count-expression-and-text/m-p/323769#M119306 2011-06-27T10:49:07Z Calculated dimension with count expression and text https://community.qlik.com/t5/QlikView/Calculated-dimension-with-count-expression-and-text/m-p/323770#M119307 <HTML><HEAD></HEAD><BODY><P> Hi,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Use this as calsulated dimention.</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; =[Secondary Theme] &amp;' '&amp; aggr(count(DISTINCT [Unique Question]),[Secondary Theme])</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Mon, 27 Jun 2011 10:54:39 GMT https://community.qlik.com/t5/QlikView/Calculated-dimension-with-count-expression-and-text/m-p/323770#M119307 kaushiknsolanki 2011-06-27T10:54:39Z Calculated dimension with count expression and text https://community.qlik.com/t5/QlikView/Calculated-dimension-with-count-expression-and-text/m-p/323771#M119308 <HTML><HEAD></HEAD><BODY><P>Thank you...Works perfectly!</P></BODY></HTML> Mon, 27 Jun 2011 11:08:05 GMT https://community.qlik.com/t5/QlikView/Calculated-dimension-with-count-expression-and-text/m-p/323771#M119308 2011-06-27T11:08:05Z