topic Restricting Data as per User Input in QlikView https://community.qlik.com/t5/QlikView/Restricting-Data-as-per-User-Input/m-p/152564#M29953 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I need to restrict the data as per user Input. For Eg if the user enter 5000 the total value in the pivot table sholud not increase more than 5000 and also it should the mxa price first.</P><P>Input : 5000</P><P>Actual Data</P><P>Product Price Amt</P><P>A 30 3000</P><P>B 40 2000</P><P>C 10 4000</P><P>B 20 2000</P><P></P><P></P><P>Output Should Be:</P><P>Product Price Amt</P><P>B 40 2000</P><P>A 30 3000</P><P>total = 5000</P><P></P><P>Thanks &amp; REgards</P><P>Deepak</P><P></P></BODY></HTML> Mon, 10 Aug 2009 12:41:04 GMT deepakk 2009-08-10T12:41:04Z Restricting Data as per User Input https://community.qlik.com/t5/QlikView/Restricting-Data-as-per-User-Input/m-p/152564#M29953 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I need to restrict the data as per user Input. For Eg if the user enter 5000 the total value in the pivot table sholud not increase more than 5000 and also it should the mxa price first.</P><P>Input : 5000</P><P>Actual Data</P><P>Product Price Amt</P><P>A 30 3000</P><P>B 40 2000</P><P>C 10 4000</P><P>B 20 2000</P><P></P><P></P><P>Output Should Be:</P><P>Product Price Amt</P><P>B 40 2000</P><P>A 30 3000</P><P>total = 5000</P><P></P><P>Thanks &amp; REgards</P><P>Deepak</P><P></P></BODY></HTML> Mon, 10 Aug 2009 12:41:04 GMT https://community.qlik.com/t5/QlikView/Restricting-Data-as-per-User-Input/m-p/152564#M29953 deepakk 2009-08-10T12:41:04Z