topic How to count different values based on same value in another column in QlikView https://community.qlik.com/t5/QlikView/How-to-count-different-values-based-on-same-value-in-another/m-p/55685#M790515 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P>I have got two columns:</P><P>Complexnr ; Year of construction</P><P>3001 ; 1990</P><P>3002 ; 1993 </P><P>3001 ; 1990</P><P>3003 ; 1995</P><P>3005 ; 2000</P><P><STRONG>3001 ; 1991</STRONG></P><P>3008 ; 2005</P><P>3001 ; 1990</P><P>3002 ; 1993</P><P>3003 ; 1995</P><P>3009 ; 2007</P><P>etc.</P><P></P><P>I would like to count rows of different construction year when Complexnr is the same. </P><P><SPAN style="font-size: 10pt;">In my example: complexnr has 2 different Years of construction.</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Could anybody help me? Thanks in advance!</SPAN></P><P><SPAN style="font-size: 10pt;">Grtz. Pascal</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z How to count different values based on same value in another column https://community.qlik.com/t5/QlikView/How-to-count-different-values-based-on-same-value-in-another/m-p/55685#M790515 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P>I have got two columns:</P><P>Complexnr ; Year of construction</P><P>3001 ; 1990</P><P>3002 ; 1993 </P><P>3001 ; 1990</P><P>3003 ; 1995</P><P>3005 ; 2000</P><P><STRONG>3001 ; 1991</STRONG></P><P>3008 ; 2005</P><P>3001 ; 1990</P><P>3002 ; 1993</P><P>3003 ; 1995</P><P>3009 ; 2007</P><P>etc.</P><P></P><P>I would like to count rows of different construction year when Complexnr is the same. </P><P><SPAN style="font-size: 10pt;">In my example: complexnr has 2 different Years of construction.</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Could anybody help me? Thanks in advance!</SPAN></P><P><SPAN style="font-size: 10pt;">Grtz. Pascal</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-count-different-values-based-on-same-value-in-another/m-p/55685#M790515 Anonymous 2020-11-25T16:16:04Z Re: How to count different values based on same value in another column https://community.qlik.com/t5/QlikView/How-to-count-different-values-based-on-same-value-in-another/m-p/55686#M790516 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>you can simply make a table with:</P><P></P><P>dimension: Complexnr</P><P>expression: count(year...)</P><P></P><P>find attached</P></BODY></HTML> Tue, 06 Feb 2018 09:00:01 GMT https://community.qlik.com/t5/QlikView/How-to-count-different-values-based-on-same-value-in-another/m-p/55686#M790516 YoussefBelloum 2018-02-06T09:00:01Z