topic Restricting dimension in a textbox. in QlikView https://community.qlik.com/t5/QlikView/Restricting-dimension-in-a-textbox/m-p/1078467#M931488 <HTML><HEAD></HEAD><BODY><P>I have a requirement that :</P><P><STRONG style="font-size: 12pt;">Among</STRONG> <STRONG>devices</STRONG> that were <STRONG>not operational</STRONG> <STRONG>this month</STRONG> ,how many were <STRONG>operational last month</STRONG> and how many were operational <STRONG>2</STRONG> <STRONG>months</STRONG> back.</P><P>Ex- </P><P>March month-<STRONG>Total Devices</STRONG>-100</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>Operational Devices</STRONG>-60</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>Non-Operational Devices</STRONG>-100-60=40</P><P></P><P>Now,</P><P><STRONG>Among these 40 d</STRONG>evices(Non operational in <STRONG>March</STRONG> month), How many device were operational in <STRONG>Feb month</STRONG>?</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; How many devices were operational in Jan month?</P><P></P><P>My question is: How to <STRONG>restrict calculation</STRONG> of jan month and feb month device count among these 40 devices only?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Pulkit_Thukral 2020-11-25T16:16:04Z Restricting dimension in a textbox. https://community.qlik.com/t5/QlikView/Restricting-dimension-in-a-textbox/m-p/1078467#M931488 <HTML><HEAD></HEAD><BODY><P>I have a requirement that :</P><P><STRONG style="font-size: 12pt;">Among</STRONG> <STRONG>devices</STRONG> that were <STRONG>not operational</STRONG> <STRONG>this month</STRONG> ,how many were <STRONG>operational last month</STRONG> and how many were operational <STRONG>2</STRONG> <STRONG>months</STRONG> back.</P><P>Ex- </P><P>March month-<STRONG>Total Devices</STRONG>-100</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>Operational Devices</STRONG>-60</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>Non-Operational Devices</STRONG>-100-60=40</P><P></P><P>Now,</P><P><STRONG>Among these 40 d</STRONG>evices(Non operational in <STRONG>March</STRONG> month), How many device were operational in <STRONG>Feb month</STRONG>?</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; How many devices were operational in Jan month?</P><P></P><P>My question is: How to <STRONG>restrict calculation</STRONG> of jan month and feb month device count among these 40 devices only?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Restricting-dimension-in-a-textbox/m-p/1078467#M931488 Pulkit_Thukral 2020-11-25T16:16:04Z