topic Re: consistency required in QlikView https://community.qlik.com/t5/QlikView/consistency-required/m-p/1345884#M414139 <HTML><HEAD></HEAD><BODY><P>A sample would help us to quickly work on this. However, one way is you have to write a calculated dimension on your dealername with your expression. Like I might be wrong but may be like below</P><P></P><P>= IF(ISnull(Aggr(yourAchieve%ExpressionHere, Month) &lt;&gt; -1, DealerName) </P><P></P><P>Then check supress when value is null for this dimension in the dimensions tab. </P></BODY></HTML> Tue, 11 Jul 2017 18:55:27 GMT vishsaggi 2017-07-11T18:55:27Z consistency required https://community.qlik.com/t5/QlikView/consistency-required/m-p/1345882#M414137 <HTML><HEAD></HEAD><BODY><P>hi all , </P><P>please&nbsp; find the attachment where i need to show the consistency of dealers . i only need to show the dealers who performance is 100 or above on a consistent basis . i am not able to avoid null values . if a dealer fails to achieve in a particular month then that dealer should be omitted . continuous achievement is required . </P></BODY></HTML> Fri, 07 Jul 2017 06:50:38 GMT https://community.qlik.com/t5/QlikView/consistency-required/m-p/1345882#M414137 Anonymous 2017-07-07T06:50:38Z Re: consistency required https://community.qlik.com/t5/QlikView/consistency-required/m-p/1345883#M414138 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Would you be able to share a sample with the expected output? (Qvw)</P></BODY></HTML> Tue, 11 Jul 2017 18:43:23 GMT https://community.qlik.com/t5/QlikView/consistency-required/m-p/1345883#M414138 el_aprendiz111 2017-07-11T18:43:23Z Re: consistency required https://community.qlik.com/t5/QlikView/consistency-required/m-p/1345884#M414139 <HTML><HEAD></HEAD><BODY><P>A sample would help us to quickly work on this. However, one way is you have to write a calculated dimension on your dealername with your expression. Like I might be wrong but may be like below</P><P></P><P>= IF(ISnull(Aggr(yourAchieve%ExpressionHere, Month) &lt;&gt; -1, DealerName) </P><P></P><P>Then check supress when value is null for this dimension in the dimensions tab. </P></BODY></HTML> Tue, 11 Jul 2017 18:55:27 GMT https://community.qlik.com/t5/QlikView/consistency-required/m-p/1345884#M414139 vishsaggi 2017-07-11T18:55:27Z Re: consistency required https://community.qlik.com/t5/QlikView/consistency-required/m-p/1345885#M414140 <HTML><HEAD></HEAD><BODY><P>Thanks for the help vishwarath but this is no !t working . let me attach the qvw file in here</P></BODY></HTML> Wed, 12 Jul 2017 04:34:06 GMT https://community.qlik.com/t5/QlikView/consistency-required/m-p/1345885#M414140 Anonymous 2017-07-12T04:34:06Z