topic Re: How to restrict value in dimension itself ? in QlikView https://community.qlik.com/t5/QlikView/How-to-restrict-value-in-dimension-itself/m-p/966957#M964609 <HTML><HEAD></HEAD><BODY><P>Dear Experts , </P><P></P><P>Any help on above report .</P></BODY></HTML> Wed, 14 Oct 2015 12:39:57 GMT 2015-10-14T12:39:57Z How to restrict value in dimension itself ? https://community.qlik.com/t5/QlikView/How-to-restrict-value-in-dimension-itself/m-p/966956#M964608 <HTML><HEAD></HEAD><BODY><P>Dear Experts ,</P><P></P><P>I am designing lost customer report , i want to restrict customer in dimension itself .</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">In my report my date selection is 13-sep-15 to 13-oct-15, i want to display lost customers alone in my report ,</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">i,e , from 13-sep-15&nbsp; to current date(today date) ,we should not have any transaction between that customer , those customer we consider as lost customer .</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">I have selected ricoh asia customer in my report , it showing last job date as 11 th sep , but actual last job date is 13th oct (please check test sheet), so we didnt loss that customer and it should not display in report . </SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Pls suggest .</SPAN></P></BODY></HTML> Tue, 13 Oct 2015 10:37:19 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-value-in-dimension-itself/m-p/966956#M964608 2015-10-13T10:37:19Z Re: How to restrict value in dimension itself ? https://community.qlik.com/t5/QlikView/How-to-restrict-value-in-dimension-itself/m-p/966957#M964609 <HTML><HEAD></HEAD><BODY><P>Dear Experts , </P><P></P><P>Any help on above report .</P></BODY></HTML> Wed, 14 Oct 2015 12:39:57 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-value-in-dimension-itself/m-p/966957#M964609 2015-10-14T12:39:57Z