topic Urgent Help in QlikView https://community.qlik.com/t5/QlikView/Urgent-Help/m-p/432229#M161132 <HTML><HEAD></HEAD><BODY><P>Hi all&nbsp; </P><P> I'm a beginner user of QlikView and i need to do this: ratio between two values (suppose the fileds are called alpha and beta); these values belong to two different years, the current selected year and the prior. So i show you an example:</P><P>year&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1998&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1999</P><P>alpha&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4</P><P>beta&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P><P>ratio&nbsp;&nbsp;&nbsp; nothing&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P></P><P>how can i find the value 2 (i.d. 4/2 ) on the field "ratio" and put all inside a pivot table?</P><P></P><P>Thanks to all for the support in advance</P></BODY></HTML> Fri, 19 Oct 2012 09:03:43 GMT 2012-10-19T09:03:43Z Urgent Help https://community.qlik.com/t5/QlikView/Urgent-Help/m-p/432229#M161132 <HTML><HEAD></HEAD><BODY><P>Hi all&nbsp; </P><P> I'm a beginner user of QlikView and i need to do this: ratio between two values (suppose the fileds are called alpha and beta); these values belong to two different years, the current selected year and the prior. So i show you an example:</P><P>year&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1998&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1999</P><P>alpha&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4</P><P>beta&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P><P>ratio&nbsp;&nbsp;&nbsp; nothing&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P></P><P>how can i find the value 2 (i.d. 4/2 ) on the field "ratio" and put all inside a pivot table?</P><P></P><P>Thanks to all for the support in advance</P></BODY></HTML> Fri, 19 Oct 2012 09:03:43 GMT https://community.qlik.com/t5/QlikView/Urgent-Help/m-p/432229#M161132 2012-10-19T09:03:43Z Re: Urgent Help https://community.qlik.com/t5/QlikView/Urgent-Help/m-p/432230#M161133 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; How are you calculating the 2.</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; is it like this.</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; alpha of current year / beta of prev year ?</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Fri, 15 Mar 2013 11:28:45 GMT https://community.qlik.com/t5/QlikView/Urgent-Help/m-p/432230#M161133 kaushiknsolanki 2013-03-15T11:28:45Z Re: Urgent Help https://community.qlik.com/t5/QlikView/Urgent-Help/m-p/432231#M161134 <HTML><HEAD></HEAD><BODY><P>Can you upload your sample application.</P></BODY></HTML> Fri, 15 Mar 2013 11:32:38 GMT https://community.qlik.com/t5/QlikView/Urgent-Help/m-p/432231#M161134 2013-03-15T11:32:38Z