Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
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.
Hi, sorry for the confusion.
nw, im just trying to help you out