topic Calculated Dimension and Expression in QlikView https://community.qlik.com/t5/QlikView/Calculated-Dimension-and-Expression/m-p/559244#M1143809 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P>this is an extension of my question posted in <A _jive_internal="true" href="https://community.qlik.com/thread/89594">http://community.qlik.com/thread/89594</A>.</P><P></P><P>Attached QV document shows top 2 metrics and their corresponding number of IDs.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 456px;"><TBODY><TR><TD class="xl63" height="17" width="98"><SPAN style="font-size: 8pt;">Dim_01</SPAN></TD><TD class="xl63" style="border-left: none;" width="98"><SPAN style="font-size: 8pt;">Dim_02</SPAN></TD><TD class="xl64" style="border-left: none;" width="98"><SPAN style="font-size: 8pt;">Top 2</SPAN></TD><TD class="xl65" width="98"><SPAN style="font-size: 8pt;">Count</SPAN></TD><TD class="xl68" width="64"><SPAN style="font-size: 8pt;">Sum</SPAN></TD></TR><TR><TD class="xl66" height="17" style="border-top: none;"><SPAN style="font-size: 8pt;">D_00</SPAN></TD><TD class="xl65" style="border-top: none; border-left: none;"><SPAN style="font-size: 8pt;">&lt;=</SPAN></TD><TD class="xl65" style="border-top: none; border-left: none;"><SPAN style="font-size: 8pt;">C1_MAX_IND</SPAN></TD><TD align="right" class="xl67" style="border-top: none; border-left: none;"><SPAN style="font-size: 8pt;">1</SPAN></TD><TD class="xl69">??</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;"><SPAN style="font-size: 8pt;">D_00</SPAN></TD><TD class="xl65" style="border-top: none; border-left: none;"><SPAN style="font-size: 8pt;">&lt;=</SPAN></TD><TD class="xl65" style="border-top: none; border-left: none;"><SPAN style="font-size: 8pt;">C2_MAX_IND</SPAN></TD><TD align="right" class="xl67" style="border-top: none; border-left: none;"><SPAN style="font-size: 8pt;">1</SPAN></TD><TD class="xl69">??</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;"><SPAN style="font-size: 8pt;">D_00</SPAN></TD><TD class="xl65" style="border-top: none; border-left: none;"><SPAN style="font-size: 8pt;">&gt;</SPAN></TD><TD class="xl65" style="border-top: none; border-left: none;"><SPAN style="font-size: 8pt;">C1_MAX_IND</SPAN></TD><TD align="right" class="xl67" style="border-top: none; border-left: none;"><SPAN style="font-size: 8pt;">1</SPAN></TD><TD class="xl69">??</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;"><SPAN style="font-size: 8pt;">D_00</SPAN></TD><TD class="xl65" style="border-top: none; border-left: none;"><SPAN style="font-size: 8pt;">&gt;</SPAN></TD><TD class="xl65" style="border-top: none; border-left: none;"><SPAN style="font-size: 8pt;">C4_MAX_IND</SPAN></TD><TD align="right" class="xl67" style="border-top: none; border-left: none;"><SPAN style="font-size: 8pt;">4</SPAN></TD><TD class="xl69">??</TD></TR></TBODY></TABLE><P></P><P>What I am trying to do is to calculate its sum as well.</P><P></P><P>My desire result is</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 456px;"><TBODY><TR><TD class="xl65" height="17" width="98">Dim_01</TD><TD class="xl65" style="border-left: none;" width="98">Dim_02</TD><TD class="xl66" style="border-left: none;" width="98">Top 2</TD><TD class="xl67" width="98">Count</TD><TD class="xl70" width="64">Sum</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">D_00</TD><TD class="xl67" style="border-top: none; border-left: none;">&lt;=</TD><TD class="xl67" style="border-top: none; border-left: none;">C1_MAX_IND</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1</TD><TD class="xl71">90</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">D_00</TD><TD class="xl67" style="border-top: none; border-left: none;">&lt;=</TD><TD class="xl67" style="border-top: none; border-left: none;">C2_MAX_IND</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1</TD><TD class="xl71">77</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">D_00</TD><TD class="xl67" style="border-top: none; border-left: none;">&gt;</TD><TD class="xl67" style="border-top: none; border-left: none;">C1_MAX_IND</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1</TD><TD class="xl71">66</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">D_00</TD><TD class="xl67" style="border-top: none; border-left: none;">&gt;</TD><TD class="xl67" style="border-top: none; border-left: none;">C4_MAX_IND</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">4</TD><TD class="xl71">141</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 02 Sep 2013 09:11:55 GMT 2013-09-02T09:11:55Z Calculated Dimension and Expression https://community.qlik.com/t5/QlikView/Calculated-Dimension-and-Expression/m-p/559244#M1143809 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P>this is an extension of my question posted in <A _jive_internal="true" href="https://community.qlik.com/thread/89594">http://community.qlik.com/thread/89594</A>.</P><P></P><P>Attached QV document shows top 2 metrics and their corresponding number of IDs.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 456px;"><TBODY><TR><TD class="xl63" height="17" width="98"><SPAN style="font-size: 8pt;">Dim_01</SPAN></TD><TD class="xl63" style="border-left: none;" width="98"><SPAN style="font-size: 8pt;">Dim_02</SPAN></TD><TD class="xl64" style="border-left: none;" width="98"><SPAN style="font-size: 8pt;">Top 2</SPAN></TD><TD class="xl65" width="98"><SPAN style="font-size: 8pt;">Count</SPAN></TD><TD class="xl68" width="64"><SPAN style="font-size: 8pt;">Sum</SPAN></TD></TR><TR><TD class="xl66" height="17" style="border-top: none;"><SPAN style="font-size: 8pt;">D_00</SPAN></TD><TD class="xl65" style="border-top: none; border-left: none;"><SPAN style="font-size: 8pt;">&lt;=</SPAN></TD><TD class="xl65" style="border-top: none; border-left: none;"><SPAN style="font-size: 8pt;">C1_MAX_IND</SPAN></TD><TD align="right" class="xl67" style="border-top: none; border-left: none;"><SPAN style="font-size: 8pt;">1</SPAN></TD><TD class="xl69">??</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;"><SPAN style="font-size: 8pt;">D_00</SPAN></TD><TD class="xl65" style="border-top: none; border-left: none;"><SPAN style="font-size: 8pt;">&lt;=</SPAN></TD><TD class="xl65" style="border-top: none; border-left: none;"><SPAN style="font-size: 8pt;">C2_MAX_IND</SPAN></TD><TD align="right" class="xl67" style="border-top: none; border-left: none;"><SPAN style="font-size: 8pt;">1</SPAN></TD><TD class="xl69">??</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;"><SPAN style="font-size: 8pt;">D_00</SPAN></TD><TD class="xl65" style="border-top: none; border-left: none;"><SPAN style="font-size: 8pt;">&gt;</SPAN></TD><TD class="xl65" style="border-top: none; border-left: none;"><SPAN style="font-size: 8pt;">C1_MAX_IND</SPAN></TD><TD align="right" class="xl67" style="border-top: none; border-left: none;"><SPAN style="font-size: 8pt;">1</SPAN></TD><TD class="xl69">??</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;"><SPAN style="font-size: 8pt;">D_00</SPAN></TD><TD class="xl65" style="border-top: none; border-left: none;"><SPAN style="font-size: 8pt;">&gt;</SPAN></TD><TD class="xl65" style="border-top: none; border-left: none;"><SPAN style="font-size: 8pt;">C4_MAX_IND</SPAN></TD><TD align="right" class="xl67" style="border-top: none; border-left: none;"><SPAN style="font-size: 8pt;">4</SPAN></TD><TD class="xl69">??</TD></TR></TBODY></TABLE><P></P><P>What I am trying to do is to calculate its sum as well.</P><P></P><P>My desire result is</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 456px;"><TBODY><TR><TD class="xl65" height="17" width="98">Dim_01</TD><TD class="xl65" style="border-left: none;" width="98">Dim_02</TD><TD class="xl66" style="border-left: none;" width="98">Top 2</TD><TD class="xl67" width="98">Count</TD><TD class="xl70" width="64">Sum</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">D_00</TD><TD class="xl67" style="border-top: none; border-left: none;">&lt;=</TD><TD class="xl67" style="border-top: none; border-left: none;">C1_MAX_IND</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1</TD><TD class="xl71">90</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">D_00</TD><TD class="xl67" style="border-top: none; border-left: none;">&lt;=</TD><TD class="xl67" style="border-top: none; border-left: none;">C2_MAX_IND</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1</TD><TD class="xl71">77</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">D_00</TD><TD class="xl67" style="border-top: none; border-left: none;">&gt;</TD><TD class="xl67" style="border-top: none; border-left: none;">C1_MAX_IND</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1</TD><TD class="xl71">66</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">D_00</TD><TD class="xl67" style="border-top: none; border-left: none;">&gt;</TD><TD class="xl67" style="border-top: none; border-left: none;">C4_MAX_IND</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">4</TD><TD class="xl71">141</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 02 Sep 2013 09:11:55 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension-and-Expression/m-p/559244#M1143809 2013-09-02T09:11:55Z Re: Calculated Dimension and Expression https://community.qlik.com/t5/QlikView/Calculated-Dimension-and-Expression/m-p/559245#M1143810 <HTML><HEAD></HEAD><BODY><P>Okay, I think I found an answer..</P></BODY></HTML> Tue, 03 Sep 2013 00:17:49 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension-and-Expression/m-p/559245#M1143810 2013-09-03T00:17:49Z