topic Re: Displaying top 3 Records in QlikView

Displaying top 3 Records

deepakqlikview_123 — Wed, 04 Sep 2013 11:48:03 GMT

Hello Friends,

I want to display top three recors in my output.Can you please guide us what should be the expression for this.

Thanks,

michael_maeuser — Wed, 04 Sep 2013 11:50:20 GMT

go to object properties "Dimension Limits" and Restrict "Show only" First 3.

if it´s straigt table that works

vikasmahajan — Wed, 04 Sep 2013 11:56:35 GMT

If you have QV 11 then as per Mr.Michael it will works , IF you have QV 9.00 version you can use rank function to achieve the same.

Vikas

Wed, 04 Sep 2013 12:48:30 GMT

Hi Deepak,

Find the attached sample file.It may help u

-Jay

deepakqlikview_123 — Thu, 05 Sep 2013 07:20:46 GMT

Thanks Maichael,

IT works perfectly for bar chart.

But right now I have to show display all details for top three records in a tabular format.

Can you please tell us how it would be possible.

Regards,

Deepak

deepakqlikview_123 — Thu, 05 Sep 2013 07:21:45 GMT

Thanks All,

But right now I have to show display all details for top three records in a tabular format.

Can you please tell us how it would be possible.

Regards,

Deepak

Thu, 05 Sep 2013 07:30:06 GMT

TRY THIS

IF(RANK(fieldname)<=3,fieldname)

Anonymous — Thu, 05 Sep 2013 11:08:19 GMT

Hi deepak tibhe

Plz go to chart properties and select presentation tab choose maxnumber. and type to 3 records and o/p shows 3 recoreds

REgards

Shivaji.ch