Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Violet
Contributor II
Contributor II

How to get % difference in line chart with two dimensions and one expression

I am trying to get % increase/decrease in a line chart having 2 dimensions and 1 expression. 

I get correct % values in case of one dimension, however when second dimension is added, the values are not correct for each individual line.

Making separate expressions is not an ideal way as there are many values in the second dimension.

What is the correct way to achieve the above?

Thanks

5 Replies
edwin
Master
Master

can you pls share more info?  what does your expression look like?  can you add sample data and the result you are expecting/getting?

also, i would suggest do this first in a table so you can easily see the numbers

Violet
Contributor II
Contributor II
Author

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.

edwin
Master
Master

hmm, thats a QlikView file.  you posted it under Qlik Sense.  i dont have QlikView anymore so maybe others can jump in.  however, it would be best if you post this question under QlikView.

Violet
Contributor II
Contributor II
Author

Hi, sorry for the confusion.

edwin
Master
Master

nw, im just trying to help you out