Rank Function ?

[qlikuser222]

Hi Everyone,

I have a requirement ,how can we use rank function to sort the column in straight table alphabetically  A to Z( but suppressing where expressions amounts are  0 and null) and have a "* "in just first row?

PFA which explains the requirement clearly.

Thanks

[qlikuser222]

Thanks for helping me understand.

Is it possible to make * sign always stays for first row? ( BAB - Market)

Like when we select  BCC - Market row or CCC - Sales or DDD - Sales the * should go away from the table, it should always stays on BAB - Market?

Thanks

[sunny_talwar]

Why not create it in the script and how did you decide it to be BAB - Market? Can this change based on the new data that comes in?

[qlikuser222]

Hi, 

Yes it can change, * sign should always be on the first row,

like if i get BAA - Market with some AMt values then * should always stay on that row instead of BAB - Market

Thanks

[sunny_talwar]

But the first row can change based on selection, no? if it is first row based on overall data... I would still say do it in script