topic Re: Use Only Function with Rank in QlikView

Use Only Function with Rank

Tue, 12 Apr 2016 09:40:31 GMT

Hi experts,

How can I show only the Field with rank = 2?

I'm trying with this expression but it give me an error (bold)

=only({<Rank(FIELD1)=2>} FIELD1)

I'm trying this in a text object!

Thanks!

Chanty4u — Tue, 12 Apr 2016 09:42:04 GMT

hi,

=only({1<Rank(FIELD1)=2>} FIELD1)

Chanty4u — Tue, 12 Apr 2016 09:45:13 GMT

chk dis

Kushal_Chawda — Tue, 12 Apr 2016 09:45:53 GMT

How you are deciding the Rank? what is the criteria?

sunny_talwar — Tue, 12 Apr 2016 09:46:05 GMT

How do you determine rank?

Tue, 12 Apr 2016 09:46:41 GMT

Hi Chanty 4u,

Thanks for your response but it still give me an error The datetype of my field is time, I don't know if it have any value to this

Tue, 12 Apr 2016 09:48:57 GMT

When I put Rank = 2 i'm thinking about the second position (the first second position)

Tue, 12 Apr 2016 09:49:03 GMT

When I put Rank = 2 i'm thinking about the second position (the first second position)

Kushal_Chawda — Tue, 12 Apr 2016 09:51:12 GMT

I am still not clear. Can you show the sample data with expected output?

sunny_talwar — Tue, 12 Apr 2016 09:51:14 GMT

But on what basis? Second highest value in Field1?

May be this:

Only({<Field1 = {"$(=Max(Field1, 2))"}>}Field1)

Only({<Field1 = {"$(=Max({1}Field1, 2))"}>}Field1)

Saravanan_Desingh — Tue, 12 Apr 2016 19:58:52 GMT

Only({<Field1={"=Rank(Field1)=2"}>}Field1)