topic Re: Expressions dynamically in QlikView https://community.qlik.com/t5/QlikView/Expressions-dynamically/m-p/664148#M241873 <HTML><HEAD></HEAD><BODY><P>Add 'Status' as a 2nd dimension , then your expression would count the records. Something like count(Status).</P><P></P><P>That would be completely dynamic.</P></BODY></HTML> Mon, 22 Sep 2014 17:10:55 GMT JonnyPoole 2014-09-22T17:10:55Z Expressions dynamically https://community.qlik.com/t5/QlikView/Expressions-dynamically/m-p/664147#M241872 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have 4 expression as below, these are based on Status field.</P><P><IMG __jive_id="67361" alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/67361_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></P><P><IMG __jive_id="67362" alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/67362_pastedImage_2.png" style="width: auto; height: auto;" /></P><P><IMG __jive_id="67363" alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/67363_pastedImage_3.png" style="width: auto; height: auto;" /></P><P><IMG __jive_id="67364" alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/67364_pastedImage_4.png" style="width: auto; height: auto;" /></P><P></P><P>My Question is I would like to keep this dynamically. Because <STRONG>Status </STRONG>field may contains different values instead of (Completed/Medium/High/Low). Based on the status field I have Sum it up and show as below.</P><P><IMG __jive_id="67365" alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/67365_pastedImage_5.png" style="width: auto; height: auto;" /></P><P></P><P>In Status field I might have (Error, Solved, In-progress, Deleted). I need the expression dynamically based on Status field values.</P><P>Second is- Is it possible without above expressions to sum up and show chart total by groups?</P><P>Can anyone help on this please.</P><P></P><P>Thanks,</P><P>Lakshmi.</P></BODY></HTML> Mon, 22 Sep 2014 17:02:42 GMT https://community.qlik.com/t5/QlikView/Expressions-dynamically/m-p/664147#M241872 2014-09-22T17:02:42Z Re: Expressions dynamically https://community.qlik.com/t5/QlikView/Expressions-dynamically/m-p/664148#M241873 <HTML><HEAD></HEAD><BODY><P>Add 'Status' as a 2nd dimension , then your expression would count the records. Something like count(Status).</P><P></P><P>That would be completely dynamic.</P></BODY></HTML> Mon, 22 Sep 2014 17:10:55 GMT https://community.qlik.com/t5/QlikView/Expressions-dynamically/m-p/664148#M241873 JonnyPoole 2014-09-22T17:10:55Z