Discussion board where members can get started with Qlik Sense.
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 :
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
Go to Solution.
try with a total i
rank(Price) / max(total aggr(rank(Price), Price))
aggr(rank(Max(price),1,1),datetime)/(rank(max( Total price),1,1)+1)
May be this