topic De-attatching in QlikView https://community.qlik.com/t5/QlikView/De-attatching/m-p/304144#M112437 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>I have show purchasing history in dashboard thorugh graph and year_id as list box.</P><P>i also want to show current stock position on same dashboard....</P><P>but prblem is that stock is current dont have any concern with past years....</P><P>so if I select any year (e.g 2009) then purchasing history working fine but stock is also changing acordingly which</P><P>are not required.</P><P></P><P>Is there any way that if user select any year only purchasing details shld chage not stock details.</P><P>if I go with de attatching option . i am also unable to dril with in the stock detail..</P><P></P><P>thnks........</P></BODY></HTML> Wed, 25 Jan 2012 09:18:06 GMT 2012-01-25T09:18:06Z De-attatching https://community.qlik.com/t5/QlikView/De-attatching/m-p/304144#M112437 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>I have show purchasing history in dashboard thorugh graph and year_id as list box.</P><P>i also want to show current stock position on same dashboard....</P><P>but prblem is that stock is current dont have any concern with past years....</P><P>so if I select any year (e.g 2009) then purchasing history working fine but stock is also changing acordingly which</P><P>are not required.</P><P></P><P>Is there any way that if user select any year only purchasing details shld chage not stock details.</P><P>if I go with de attatching option . i am also unable to dril with in the stock detail..</P><P></P><P>thnks........</P></BODY></HTML> Wed, 25 Jan 2012 09:18:06 GMT https://community.qlik.com/t5/QlikView/De-attatching/m-p/304144#M112437 2012-01-25T09:18:06Z De-attatching https://community.qlik.com/t5/QlikView/De-attatching/m-p/304145#M112438 <HTML><HEAD></HEAD><BODY><P> yes use set analysis </P><P></P><P></P><P>in your stock expression use something like</P><P></P><P></P><P></P><P>sum({&lt;Year=&gt;}QuantityInStock)</P><P></P><P></P><P>that way the expression will diregard any selection in the year field</P></BODY></HTML> Wed, 25 Jan 2012 09:23:52 GMT https://community.qlik.com/t5/QlikView/De-attatching/m-p/304145#M112438 lironbaram 2012-01-25T09:23:52Z De-attatching https://community.qlik.com/t5/QlikView/De-attatching/m-p/304146#M112439 <HTML><HEAD></HEAD><BODY><P>Absolutly Perfect .... thnks Liron</P></BODY></HTML> Wed, 01 Feb 2012 06:16:02 GMT https://community.qlik.com/t5/QlikView/De-attatching/m-p/304146#M112439 2012-02-01T06:16:02Z