topic fix filter in QlikView https://community.qlik.com/t5/QlikView/fix-filter/m-p/520819#M553670 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: 'comic sans ms', sans-serif;">Hi there,</SPAN></P><P><SPAN style="font-family: 'comic sans ms', sans-serif;"><BR /></SPAN></P><P><SPAN style="font-family: 'comic sans ms', sans-serif;">Im my model I would like to have a fix filter on one sheet , regardless of what the user is choosing, The only field that change will be the date field.</SPAN></P><P><SPAN style="font-family: 'comic sans ms', sans-serif;"><BR /></SPAN></P><P><SPAN style="font-family: 'comic sans ms', sans-serif;">example ...</SPAN></P><P><SPAN style="font-family: 'comic sans ms', sans-serif;"><BR /></SPAN></P><P><SPAN style="font-family: 'comic sans ms', sans-serif;">I want to do the sum always when Cores is &lt;=4&nbsp; but when Status is base then sum Processor *.20 and when Status is New then just sum processor. But I want the values to change based on the date the user selected </SPAN></P><P><SPAN style="font-family: 'comic sans ms', sans-serif;"> <BR /></SPAN></P><P><SPAN style="font-family: 'comic sans ms', sans-serif;">sum(if(cores &lt;=4, processor * if(Status='Base',0.20,if(Status='New',1,1))))</SPAN></P></BODY></HTML> Mon, 07 Oct 2013 12:21:10 GMT 2013-10-07T12:21:10Z fix filter https://community.qlik.com/t5/QlikView/fix-filter/m-p/520819#M553670 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: 'comic sans ms', sans-serif;">Hi there,</SPAN></P><P><SPAN style="font-family: 'comic sans ms', sans-serif;"><BR /></SPAN></P><P><SPAN style="font-family: 'comic sans ms', sans-serif;">Im my model I would like to have a fix filter on one sheet , regardless of what the user is choosing, The only field that change will be the date field.</SPAN></P><P><SPAN style="font-family: 'comic sans ms', sans-serif;"><BR /></SPAN></P><P><SPAN style="font-family: 'comic sans ms', sans-serif;">example ...</SPAN></P><P><SPAN style="font-family: 'comic sans ms', sans-serif;"><BR /></SPAN></P><P><SPAN style="font-family: 'comic sans ms', sans-serif;">I want to do the sum always when Cores is &lt;=4&nbsp; but when Status is base then sum Processor *.20 and when Status is New then just sum processor. But I want the values to change based on the date the user selected </SPAN></P><P><SPAN style="font-family: 'comic sans ms', sans-serif;"> <BR /></SPAN></P><P><SPAN style="font-family: 'comic sans ms', sans-serif;">sum(if(cores &lt;=4, processor * if(Status='Base',0.20,if(Status='New',1,1))))</SPAN></P></BODY></HTML> Mon, 07 Oct 2013 12:21:10 GMT https://community.qlik.com/t5/QlikView/fix-filter/m-p/520819#M553670 2013-10-07T12:21:10Z Re: fix filter https://community.qlik.com/t5/QlikView/fix-filter/m-p/520820#M553671 <HTML><HEAD></HEAD><BODY><P>Try something like: sum({1&lt;Date=p(Date)&gt;}if(cores &lt;=4, processor * if(Status='Base',0.20,if(Status='New',1,1))))</P></BODY></HTML> Mon, 07 Oct 2013 12:41:42 GMT https://community.qlik.com/t5/QlikView/fix-filter/m-p/520820#M553671 Gysbert_Wassenaar 2013-10-07T12:41:42Z