Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Invalid dimension for dimension chart

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 :

DatetimePrice
1/1/2017 11:005
1/1/2017 12:0012
1/1/2017 13:003
1/1/2017 14:004
1/1/2017 15:005
1/1/2017 16:003

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)

1 Solution

Accepted Solutions
MVP
MVP

Re: Invalid dimension for dimension chart

try with a total i

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

2 Replies
MVP
MVP

Re: Invalid dimension for dimension chart

try with a total i

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

kkkumar82
Valued Contributor III

Re: Invalid dimension for dimension chart

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


May be this