topic Re: How to get % difference in line chart with two dimensions and one expression in App Development https://community.qlik.com/t5/App-Development/How-to-get-difference-in-line-chart-with-two-dimensions-and-one/m-p/1817984#M67014 <P>can you pls share more info?&nbsp; what does your expression look like?&nbsp; can you add sample data and the result you are expecting/getting?</P><P>also, i would suggest do this first in a table so you can easily see the numbers</P> Fri, 25 Jun 2021 17:52:49 GMT edwin 2021-06-25T17:52:49Z How to get % difference in line chart with two dimensions and one expression https://community.qlik.com/t5/App-Development/How-to-get-difference-in-line-chart-with-two-dimensions-and-one/m-p/1817771#M66990 <P>I am trying to get % increase/decrease in a line chart having 2 dimensions and 1 expression.&nbsp;</P><P>I get correct % values in case of one dimension, however when second dimension is added, the values are not correct for each individual line.</P><P>Making separate expressions is not an ideal way as there are many values in the second dimension.</P><P>What is the correct way to achieve the above?</P><P>Thanks</P> Fri, 25 Jun 2021 20:45:09 GMT https://community.qlik.com/t5/App-Development/How-to-get-difference-in-line-chart-with-two-dimensions-and-one/m-p/1817771#M66990 Violet 2021-06-25T20:45:09Z Re: How to get % difference in line chart with two dimensions and one expression https://community.qlik.com/t5/App-Development/How-to-get-difference-in-line-chart-with-two-dimensions-and-one/m-p/1817984#M67014 <P>can you pls share more info?&nbsp; what does your expression look like?&nbsp; can you add sample data and the result you are expecting/getting?</P><P>also, i would suggest do this first in a table so you can easily see the numbers</P> Fri, 25 Jun 2021 17:52:49 GMT https://community.qlik.com/t5/App-Development/How-to-get-difference-in-line-chart-with-two-dimensions-and-one/m-p/1817984#M67014 edwin 2021-06-25T17:52:49Z Re: How to get % difference in line chart with two dimensions and one expression https://community.qlik.com/t5/App-Development/How-to-get-difference-in-line-chart-with-two-dimensions-and-one/m-p/1818031#M67023 <P>Hi Edwin, I've attached a sample file to explain better. The first chart is what I want but am getting weird % values, unlike the second chart that works fine for total value.</P> Fri, 25 Jun 2021 20:47:43 GMT https://community.qlik.com/t5/App-Development/How-to-get-difference-in-line-chart-with-two-dimensions-and-one/m-p/1818031#M67023 Violet 2021-06-25T20:47:43Z Re: How to get % difference in line chart with two dimensions and one expression https://community.qlik.com/t5/App-Development/How-to-get-difference-in-line-chart-with-two-dimensions-and-one/m-p/1818036#M67024 <P>hmm, thats a QlikView file.&nbsp; you posted it under Qlik Sense.&nbsp; i dont have QlikView anymore so maybe others can jump in.&nbsp; however, it would be best if you post this question under QlikView.</P> Sat, 26 Jun 2021 00:41:47 GMT https://community.qlik.com/t5/App-Development/How-to-get-difference-in-line-chart-with-two-dimensions-and-one/m-p/1818036#M67024 edwin 2021-06-26T00:41:47Z Re: How to get % difference in line chart with two dimensions and one expression https://community.qlik.com/t5/App-Development/How-to-get-difference-in-line-chart-with-two-dimensions-and-one/m-p/1818046#M67026 <P>Hi, sorry for the confusion.</P> Sat, 26 Jun 2021 06:15:38 GMT https://community.qlik.com/t5/App-Development/How-to-get-difference-in-line-chart-with-two-dimensions-and-one/m-p/1818046#M67026 Violet 2021-06-26T06:15:38Z Re: How to get % difference in line chart with two dimensions and one expression https://community.qlik.com/t5/App-Development/How-to-get-difference-in-line-chart-with-two-dimensions-and-one/m-p/1818408#M67068 <P>nw, im just trying to help you out</P> Mon, 28 Jun 2021 20:00:15 GMT https://community.qlik.com/t5/App-Development/How-to-get-difference-in-line-chart-with-two-dimensions-and-one/m-p/1818408#M67068 edwin 2021-06-28T20:00:15Z