Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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!