Invalid dimension for dimension chart

[#1]

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)

[maxgro · Accepted solution]

try with a total i

rank(Price) / max(total aggr(rank(Price), Price))

[kkkumar82]

aggr(rank(Max(price),1,1),datetime)/(rank(max( Total price),1,1)+1)

May be this