topic Re: Get the difference amounts in two different years in QlikView https://community.qlik.com/t5/QlikView/Get-the-difference-amounts-in-two-different-years/m-p/682456#M1318468 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Yes I got the solution, Is there any special way to close the thread? sorry I'm actually new here <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P><P>Thanks</P><P></P><P>Farzaneh</P></BODY></HTML> Tue, 02 Sep 2014 05:55:12 GMT 2014-09-02T05:55:12Z Get the difference amounts in two different years https://community.qlik.com/t5/QlikView/Get-the-difference-amounts-in-two-different-years/m-p/682446#M1318458 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have two dimensions which one of them is office names and the other one is years. I calculated the sum of sale amount of each office name in each year in expression column . How can I have the differences sale amount between two years ( current and previous year) in one office ?</P><P>Note: 92 and 93 are years</P><P></P><P><IMG alt="QVHelp.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/65635_QVHelp.png" style="width: 620px; height: 301px;" /></P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Get-the-difference-amounts-in-two-different-years/m-p/682446#M1318458 2026-01-26T18:19:17Z Re: Get the difference amounts in two different years https://community.qlik.com/t5/QlikView/Get-the-difference-amounts-in-two-different-years/m-p/682447#M1318459 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>No need to calculate for office separately.</P><P>Just add office to your dimension.</P><P></P><P>Can you post sample app with expected output to help you out further.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Mon, 01 Sep 2014 08:42:20 GMT https://community.qlik.com/t5/QlikView/Get-the-difference-amounts-in-two-different-years/m-p/682447#M1318459 ashfaq_haseeb 2014-09-01T08:42:20Z Re: Get the difference amounts in two different years https://community.qlik.com/t5/QlikView/Get-the-difference-amounts-in-two-different-years/m-p/682448#M1318460 <HTML><HEAD></HEAD><BODY><P>I have already office names as one of my dimensions . yes sure I&nbsp; have a sample app to post but I dont know how to do this here <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P><P></P><P>Thanks in advance</P></BODY></HTML> Mon, 01 Sep 2014 09:15:41 GMT https://community.qlik.com/t5/QlikView/Get-the-difference-amounts-in-two-different-years/m-p/682448#M1318460 2014-09-01T09:15:41Z Re: Re: Get the difference amounts in two different years https://community.qlik.com/t5/QlikView/Get-the-difference-amounts-in-two-different-years/m-p/682449#M1318461 <HTML><HEAD></HEAD><BODY><P>When replying click <EM>Use Advanced Editor</EM> and the <EM>Attach</EM> will appear.</P></BODY></HTML> Mon, 01 Sep 2014 09:18:33 GMT https://community.qlik.com/t5/QlikView/Get-the-difference-amounts-in-two-different-years/m-p/682449#M1318461 Anonymous 2014-09-01T09:18:33Z Re: Get the difference amounts in two different years https://community.qlik.com/t5/QlikView/Get-the-difference-amounts-in-two-different-years/m-p/682450#M1318462 <HTML><HEAD></HEAD><BODY><P>Thank you <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 01 Sep 2014 09:42:50 GMT https://community.qlik.com/t5/QlikView/Get-the-difference-amounts-in-two-different-years/m-p/682450#M1318462 2014-09-01T09:42:50Z Re: Re: Get the difference amounts in two different years https://community.qlik.com/t5/QlikView/Get-the-difference-amounts-in-two-different-years/m-p/682451#M1318463 <HTML><HEAD></HEAD><BODY><P>This is my sample app</P></BODY></HTML> Mon, 01 Sep 2014 09:44:54 GMT https://community.qlik.com/t5/QlikView/Get-the-difference-amounts-in-two-different-years/m-p/682451#M1318463 2014-09-01T09:44:54Z Re: Re: Re: Get the difference amounts in two different years https://community.qlik.com/t5/QlikView/Get-the-difference-amounts-in-two-different-years/m-p/682452#M1318464 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>may be like this.</P><P>You can modify formula as required.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Mon, 01 Sep 2014 09:54:10 GMT https://community.qlik.com/t5/QlikView/Get-the-difference-amounts-in-two-different-years/m-p/682452#M1318464 ashfaq_haseeb 2014-09-01T09:54:10Z Re: Re: Re: Get the difference amounts in two different years https://community.qlik.com/t5/QlikView/Get-the-difference-amounts-in-two-different-years/m-p/682453#M1318465 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please find attached file for solution.</P><P></P><P>Changed Dimension and expressions.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Mon, 01 Sep 2014 10:00:07 GMT https://community.qlik.com/t5/QlikView/Get-the-difference-amounts-in-two-different-years/m-p/682453#M1318465 jagan 2014-09-01T10:00:07Z Re: Re: Get the difference amounts in two different years https://community.qlik.com/t5/QlikView/Get-the-difference-amounts-in-two-different-years/m-p/682454#M1318466 <HTML><HEAD></HEAD><BODY><P>This is exactly what I want <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> Thank you so much !</P></BODY></HTML> Mon, 01 Sep 2014 10:38:40 GMT https://community.qlik.com/t5/QlikView/Get-the-difference-amounts-in-two-different-years/m-p/682454#M1318466 2014-09-01T10:38:40Z Re: Re: Get the difference amounts in two different years https://community.qlik.com/t5/QlikView/Get-the-difference-amounts-in-two-different-years/m-p/682455#M1318467 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>If you got the solution please close this thread.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Tue, 02 Sep 2014 01:38:08 GMT https://community.qlik.com/t5/QlikView/Get-the-difference-amounts-in-two-different-years/m-p/682455#M1318467 jagan 2014-09-02T01:38:08Z Re: Get the difference amounts in two different years https://community.qlik.com/t5/QlikView/Get-the-difference-amounts-in-two-different-years/m-p/682456#M1318468 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Yes I got the solution, Is there any special way to close the thread? sorry I'm actually new here <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P><P>Thanks</P><P></P><P>Farzaneh</P></BODY></HTML> Tue, 02 Sep 2014 05:55:12 GMT https://community.qlik.com/t5/QlikView/Get-the-difference-amounts-in-two-different-years/m-p/682456#M1318468 2014-09-02T05:55:12Z Re: Get the difference amounts in two different years https://community.qlik.com/t5/QlikView/Get-the-difference-amounts-in-two-different-years/m-p/682457#M1318469 <HTML><HEAD></HEAD><BODY><P>By giving Correct Answer you closed this thread.</P><P>Regards,</P><P>jagan.</P></BODY></HTML> Tue, 02 Sep 2014 05:56:11 GMT https://community.qlik.com/t5/QlikView/Get-the-difference-amounts-in-two-different-years/m-p/682457#M1318469 jagan 2014-09-02T05:56:11Z