Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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 II
Master II

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 II
Master II

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 II
Master II

nw, im just trying to help you out