Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Manish
Contributor III
Contributor III

how to display bottom N values including 0 values using Rank function

Hi Guys 

I want to display bottom N values including 0 values in a straight table having 2 dimensions and 1 Expression.

I am attaching a sample qvw file. 

When i am trying to show bottom 5 , i am getting below output 

TeamOffice 
AO1-100
EO5-50
FO6-40

 

Expected Output:

TeamOffice 
AO1-100
EO5-50
FO6-40
BO20
CO30

 

Please let me know what i am doing wrong.

 

Thanks in advance.

1 Solution

Accepted Solutions
MayilVahanan

Hi @Manish 

PFA

Thanks & Regards,
Mayil Vahanan R
Please close the thread by marking correct answer & likes if you like the post.

View solution in original post

1 Reply
MayilVahanan

Hi @Manish 

PFA

Thanks & Regards,
Mayil Vahanan R
Please close the thread by marking correct answer & likes if you like the post.