Hi,
I am a very new user of Qlik sense and I experience some trouble with line charts.
I have a table for prices which has two columns. Here's a sample of my table :
| Datetime | Price |
|---|
| 1/1/2017 11:00 | 5 |
| 1/1/2017 12:00 | 12 |
| 1/1/2017 13:00 | 3 |
| 1/1/2017 14:00 | 4 |
| 1/1/2017 15:00 | 5 |
| 1/1/2017 16:00 | 3 |
And I want to create a line chart where the Y-axis would be the price and the X axis would be : (n/m+1)
where n=rank(price) and m would be equal to the highest rank of the price (so the rank of the lowest price)
The solution I've found leads me to a invalid dimension for my line chart dimension. The function is the following
aggr(rank(price,1,1),datetime)/(rank(max(price),1,1)+1)
