topic To provide an expression (instead of selecting a field) in statistics box in QlikView https://community.qlik.com/t5/QlikView/To-provide-an-expression-instead-of-selecting-a-field-in/m-p/340537#M577089 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a dashboard which have muliple tabs.</P><P>One tab deals with a high level analysis. We have a field named <STRONG>survey_id</STRONG>. So in the generic tab, I have put in a statistics box, the count of <STRONG>survey_id</STRONG></P><P></P><P>The next tab is more specific one. I need to display the count of <STRONG>survey_id </STRONG>where <STRONG>survey_type</STRONG>='outside'.</P><P>(in normal list box, this will be as <EM>=if(survey_type='outise', survey_id) )</EM></P><P>But in statistics box I do not see an option to give expression instead of selecting an available field.</P><P></P><P>Is there a solution for this other than me creating a sperate field for this in the backend. I need to use statistics box so that this component will be consistent across the tabs.</P></BODY></HTML> Tue, 08 May 2012 06:45:06 GMT 2012-05-08T06:45:06Z To provide an expression (instead of selecting a field) in statistics box https://community.qlik.com/t5/QlikView/To-provide-an-expression-instead-of-selecting-a-field-in/m-p/340537#M577089 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a dashboard which have muliple tabs.</P><P>One tab deals with a high level analysis. We have a field named <STRONG>survey_id</STRONG>. So in the generic tab, I have put in a statistics box, the count of <STRONG>survey_id</STRONG></P><P></P><P>The next tab is more specific one. I need to display the count of <STRONG>survey_id </STRONG>where <STRONG>survey_type</STRONG>='outside'.</P><P>(in normal list box, this will be as <EM>=if(survey_type='outise', survey_id) )</EM></P><P>But in statistics box I do not see an option to give expression instead of selecting an available field.</P><P></P><P>Is there a solution for this other than me creating a sperate field for this in the backend. I need to use statistics box so that this component will be consistent across the tabs.</P></BODY></HTML> Tue, 08 May 2012 06:45:06 GMT https://community.qlik.com/t5/QlikView/To-provide-an-expression-instead-of-selecting-a-field-in/m-p/340537#M577089 2012-05-08T06:45:06Z