topic %fields and its effect in QlikView https://community.qlik.com/t5/QlikView/fields-and-its-effect/m-p/1105458#M366121 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a field say [%rfflag]. it got values 'Y','N' and have a expression say count({&lt;[%rfflag],[Date]&gt;}id).</P><P>I don't want [%rfflag],[Date] fields affect the count of id's . So , ihave coded this way but when I make selections for the [%rfflag]; it is actually affecting the count of id's.</P><P></P><P>Can anyone tell me wats going wrong.</P></BODY></HTML> Tue, 14 Jun 2016 05:28:27 GMT 2016-06-14T05:28:27Z %fields and its effect https://community.qlik.com/t5/QlikView/fields-and-its-effect/m-p/1105458#M366121 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a field say [%rfflag]. it got values 'Y','N' and have a expression say count({&lt;[%rfflag],[Date]&gt;}id).</P><P>I don't want [%rfflag],[Date] fields affect the count of id's . So , ihave coded this way but when I make selections for the [%rfflag]; it is actually affecting the count of id's.</P><P></P><P>Can anyone tell me wats going wrong.</P></BODY></HTML> Tue, 14 Jun 2016 05:28:27 GMT https://community.qlik.com/t5/QlikView/fields-and-its-effect/m-p/1105458#M366121 2016-06-14T05:28:27Z Re: %fields and its effect https://community.qlik.com/t5/QlikView/fields-and-its-effect/m-p/1105459#M366122 <HTML><HEAD></HEAD><BODY><P>It should not. Could you post a sample qvw that demonstrates the issue?</P></BODY></HTML> Tue, 14 Jun 2016 05:32:00 GMT https://community.qlik.com/t5/QlikView/fields-and-its-effect/m-p/1105459#M366122 tresB 2016-06-14T05:32:00Z Re: %fields and its effect https://community.qlik.com/t5/QlikView/fields-and-its-effect/m-p/1105460#M366123 <HTML><HEAD></HEAD><BODY><P>may be like this</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> count({&lt;[%rfflag]=,[Date]=&gt;}id)</SPAN></P></BODY></HTML> Tue, 14 Jun 2016 05:32:47 GMT https://community.qlik.com/t5/QlikView/fields-and-its-effect/m-p/1105460#M366123 arulsettu 2016-06-14T05:32:47Z Re: %fields and its effect https://community.qlik.com/t5/QlikView/fields-and-its-effect/m-p/1105461#M366124 <HTML><HEAD></HEAD><BODY><P>I tried even this:)</P></BODY></HTML> Tue, 14 Jun 2016 05:34:13 GMT https://community.qlik.com/t5/QlikView/fields-and-its-effect/m-p/1105461#M366124 2016-06-14T05:34:13Z Re: %fields and its effect https://community.qlik.com/t5/QlikView/fields-and-its-effect/m-p/1105462#M366125 <HTML><HEAD></HEAD><BODY><P>Hi prudhvi,</P><P>Is this expression in a chart?</P><P>Could you share an screenshot please?</P><P></P><P>Regards!</P></BODY></HTML> Tue, 14 Jun 2016 06:31:47 GMT https://community.qlik.com/t5/QlikView/fields-and-its-effect/m-p/1105462#M366125 Anonymous 2016-06-14T06:31:47Z Re: %fields and its effect https://community.qlik.com/t5/QlikView/fields-and-its-effect/m-p/1105463#M366126 <HTML><HEAD></HEAD><BODY><P>try this</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px;"> count(<EM><STRONG>{1}</STRONG></EM>{&lt;[%rfflag],[Date]&gt;}id).</SPAN></P></BODY></HTML> Tue, 14 Jun 2016 06:35:03 GMT https://community.qlik.com/t5/QlikView/fields-and-its-effect/m-p/1105463#M366126 Chanty4u 2016-06-14T06:35:03Z Re: %fields and its effect https://community.qlik.com/t5/QlikView/fields-and-its-effect/m-p/1105464#M366127 <HTML><HEAD></HEAD><BODY><P>Please try </P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=Count({1}{&lt;[%rfflag],[Date]&gt;}id)</SPAN></P></BODY></HTML> Tue, 14 Jun 2016 06:46:28 GMT https://community.qlik.com/t5/QlikView/fields-and-its-effect/m-p/1105464#M366127 ashwanin 2016-06-14T06:46:28Z Re: %fields and its effect https://community.qlik.com/t5/QlikView/fields-and-its-effect/m-p/1105465#M366128 <HTML><HEAD></HEAD><BODY><P>There are many field selections which have to affect this so, I cant use:</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=Count({1}{&lt;[%rfflag],[Date]&gt;}id)</SPAN></P></BODY></HTML> Tue, 14 Jun 2016 06:49:29 GMT https://community.qlik.com/t5/QlikView/fields-and-its-effect/m-p/1105465#M366128 2016-06-14T06:49:29Z Re: %fields and its effect https://community.qlik.com/t5/QlikView/fields-and-its-effect/m-p/1105466#M366129 <HTML><HEAD></HEAD><BODY><P>Try</P><P>count({<STRONG>1</STRONG>&lt;[%rfflag],[Date]&gt;}id)</P></BODY></HTML> Tue, 14 Jun 2016 07:34:21 GMT https://community.qlik.com/t5/QlikView/fields-and-its-effect/m-p/1105466#M366129 sasiparupudi1 2016-06-14T07:34:21Z Re: %fields and its effect https://community.qlik.com/t5/QlikView/fields-and-its-effect/m-p/1105467#M366130 <HTML><HEAD></HEAD><BODY><P>no improvement</P></BODY></HTML> Tue, 14 Jun 2016 08:47:32 GMT https://community.qlik.com/t5/QlikView/fields-and-its-effect/m-p/1105467#M366130 2016-06-14T08:47:32Z Re: %fields and its effect https://community.qlik.com/t5/QlikView/fields-and-its-effect/m-p/1105468#M366131 <HTML><HEAD></HEAD><BODY><P>count({&lt;[%rfflag]={*},[Date]={*}&gt;}id).</P></BODY></HTML> Tue, 14 Jun 2016 08:52:40 GMT https://community.qlik.com/t5/QlikView/fields-and-its-effect/m-p/1105468#M366131 sasiparupudi1 2016-06-14T08:52:40Z Re: %fields and its effect https://community.qlik.com/t5/QlikView/fields-and-its-effect/m-p/1105469#M366132 <HTML><HEAD></HEAD><BODY><P>No improvement in your response as well. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/silly.png" /> You have to help us here to be helped. Please share a sample&nbsp; and check the link to know how . <A href="https://community.qlik.com/docs/DOC-1290">Preparing examples for Upload - Reduction and Data Scrambling</A></P></BODY></HTML> Tue, 14 Jun 2016 09:02:03 GMT https://community.qlik.com/t5/QlikView/fields-and-its-effect/m-p/1105469#M366132 tresB 2016-06-14T09:02:03Z Re: %fields and its effect https://community.qlik.com/t5/QlikView/fields-and-its-effect/m-p/1105470#M366133 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>try with only %rfflag and see if it the selections still affecting the count?&nbsp; </P><P>count({&lt;[%rfflag]=&gt;}id)</P></BODY></HTML> Tue, 14 Jun 2016 11:34:56 GMT https://community.qlik.com/t5/QlikView/fields-and-its-effect/m-p/1105470#M366133 sasiparupudi1 2016-06-14T11:34:56Z