Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

alec1982
Valued Contributor II

Ranking Issue

hi,

I am trying to use rank function and the issue I have is it ranks each distinct value of the dimension and then start the rank again while i need to rank all the dimensions.

Here is my dimension and expression

Start Date: date(if(Flag_ = 1 , [Mature Date_]),'MMM YY')

End Date: date(if(Flag = 1 ,[Date]),'MMM YY')

Price:

(Sum({$<Flag = {'1'}>}[Price]) - above(Sum({$<Flag_ = {'1'}>}[Price_])))/

([Date] - [Date_]))

Anyone knows how I can do rank for all dates?

Thanks,

Alec

1 Solution

Accepted Solutions
MVP
MVP

Re: Ranking Issue

Try

Rank(TOTAL YourExpressionToRank)

4 Replies
MVP
MVP

Re: Ranking Issue

Try

Rank(TOTAL YourExpressionToRank)

Re: Ranking Issue

Where is your Rank expression?

jyothish8807
Honored Contributor II

Re: Ranking Issue

Hi Alec,

Its a bit confusion.

Why do you have two date as dimension ?

What is the difference between Mature date and Date ?

Can you share a sample app, then it will be helpful.

Regards

KC

Best Regards,
KC
alec1982
Valued Contributor II

Re: Ranking Issue

thank you all.. Stefan got it !

Community Browser