Re: Displaying top 3 Records - Qlik Community

deepakqlikview_123 · ‎2013-09-04

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 · ‎2013-09-04

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

if it´s straigt table that works

vikasmahajan · ‎2013-09-04

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

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Report Inappropriate Content · ‎2013-09-04

Hi Deepak,

Find the attached sample file.It may help u

-Jay

deepakqlikview_123 · ‎2013-09-05

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 · ‎2013-09-05

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

Report Inappropriate Content · ‎2013-09-05

HI

TRY THIS

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

Anonymous · ‎2013-09-05

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