Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Manish
Creator
Creator

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 & give 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 & give likes if you like the post.