topic Conditional Expression in QlikView https://community.qlik.com/t5/QlikView/Conditional-Expression/m-p/425024#M1148522 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm struggling with the syntax of the following expression.</P><P></P><P>I have a slider bar telling me the "Number of Days" between an invoice issuance and payment delivered. I want to create a top 5 vendor bar chart that shows the % of total spend given "Number of Days".</P><P></P><P>My expression is currently: =sum(TOTAL(&lt;No of Days&gt; [Spend]))/sum([Spend]). My dimension is Vendor. </P><P></P><P>Any ideas why this is not working?</P><P></P><P>Thanks so much!!</P></BODY></HTML> Thu, 30 May 2013 13:50:43 GMT 2013-05-30T13:50:43Z Conditional Expression https://community.qlik.com/t5/QlikView/Conditional-Expression/m-p/425024#M1148522 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm struggling with the syntax of the following expression.</P><P></P><P>I have a slider bar telling me the "Number of Days" between an invoice issuance and payment delivered. I want to create a top 5 vendor bar chart that shows the % of total spend given "Number of Days".</P><P></P><P>My expression is currently: =sum(TOTAL(&lt;No of Days&gt; [Spend]))/sum([Spend]). My dimension is Vendor. </P><P></P><P>Any ideas why this is not working?</P><P></P><P>Thanks so much!!</P></BODY></HTML> Thu, 30 May 2013 13:50:43 GMT https://community.qlik.com/t5/QlikView/Conditional-Expression/m-p/425024#M1148522 2013-05-30T13:50:43Z