topic Filtering a dimension in QlikView https://community.qlik.com/t5/QlikView/Filtering-a-dimension/m-p/442083#M562028 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>I have prepared a table where only one date should be shown.</P><P></P><P>I've insert a dimension "Date" through this expression:</P><P></P><P>If(Date_Parameter=Date(today()-1),Date_Parameter)</P><P></P><P>My table is workin fine only in the case I'm really selekting a certain date i a selection box (&gt;&gt;today()-1)&nbsp; But if I deselect it the the update never stops.</P><P></P><P>What I somehow think, is that the addes formulas (one of them is avg(some_par)) are still taking the avg of all dates and not of today()-1...</P><P></P><P></P><P></P><P>I hope you understand my problem</P><P></P><P></P><P>Thx for help</P></BODY></HTML> Thu, 14 Mar 2013 14:31:38 GMT Anonymous 2013-03-14T14:31:38Z Filtering a dimension https://community.qlik.com/t5/QlikView/Filtering-a-dimension/m-p/442083#M562028 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>I have prepared a table where only one date should be shown.</P><P></P><P>I've insert a dimension "Date" through this expression:</P><P></P><P>If(Date_Parameter=Date(today()-1),Date_Parameter)</P><P></P><P>My table is workin fine only in the case I'm really selekting a certain date i a selection box (&gt;&gt;today()-1)&nbsp; But if I deselect it the the update never stops.</P><P></P><P>What I somehow think, is that the addes formulas (one of them is avg(some_par)) are still taking the avg of all dates and not of today()-1...</P><P></P><P></P><P></P><P>I hope you understand my problem</P><P></P><P></P><P>Thx for help</P></BODY></HTML> Thu, 14 Mar 2013 14:31:38 GMT https://community.qlik.com/t5/QlikView/Filtering-a-dimension/m-p/442083#M562028 Anonymous 2013-03-14T14:31:38Z