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: 
bachourmtcb
Contributor
Contributor

Measure that shows difference between stock of today and day before

I'd like to create a measure that is the variation of my stock from one day to another. Basically I want a measure that tells me if my stock on a given day is greater or smaller than the day before a line chart.

Labels (1)
1 Solution

Accepted Solutions
cheenu_janakira
Creator III
Creator III

Hi Bachourmtcb,

Switch the bar chart to a table, if you have an EXPR in the first colum, try a 2nd expression such as COLUMN(1) - ABOVE(COLUMN(1)) and see what it shows. Then convert back to a bar chart (switch to a combo) and put the 2nd expression to the 2nd axis.

This might give you a hint.

KR,

Cheenu

View solution in original post

2 Replies
cheenu_janakira
Creator III
Creator III

Hi Bachourmtcb,

Switch the bar chart to a table, if you have an EXPR in the first colum, try a 2nd expression such as COLUMN(1) - ABOVE(COLUMN(1)) and see what it shows. Then convert back to a bar chart (switch to a combo) and put the 2nd expression to the 2nd axis.

This might give you a hint.

KR,

Cheenu

bachourmtcb
Contributor
Contributor
Author

Thank you! It was a very useful tip!