Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
sarfaraz_sheikh
Contributor III
Contributor III

Regarding Rank() in Expression for TOP 10

Dear All,

I used rank() in expression defination for calculating top 10...and i got that but  in front of dimension other than top 10 showing " - " this symbol .....how i can suppress them in chart...

below is my expression :-

=if(Rank(Count( {<SUB_VERTICAL_DESC={'AUTO'} >} SI_NO)) <=10,Count( {<SUB_VERTICAL_DESC={'AUTO'} >} SI_NO))

Kindly help !!!!

Regards

Sarfaraz

17 Replies
arulsettu
Master III
Master III

hi try this

=if(replace(Rank(Count( {<SUB_VERTICAL_DESC={'AUTO'} >} SI_NO)) <=10,Count( {<SUB_VERTICAL_DESC={'AUTO'} >} SI_NO),'-',''))

its_anandrjs
Champion III
Champion III

Hi,

Did you try Suppress when value is Null option to check.

Regards

Anand

sarfaraz_sheikh
Contributor III
Contributor III
Author

yes.......and i am using pivot table ........

Sarfaraz

sarfaraz_sheikh
Contributor III
Contributor III
Author

Hi Arul,

Showing error in expression .........

Sarfaraz


Not applicable

Hi,

Instead of using rank in expression, use it in calculated dimension aggr(if(Count( {<SUB_VERTICAL_DESC={'AUTO'} >} SI_NO)) <=10,Your_dim),Your_dim) and check suppress nulls values for dimension.

Use normal expression in expression.

cheers,

amay

sarfaraz_sheikh
Contributor III
Contributor III
Author

Dear Amay,

I have done the same what u r saying to do me...by doing so i am not getting the expected result .......in expression i am getting expected result .....i just want to suppress the null value ...thats it

Sarfaraz

Not applicable

Hi,

I have attached a sample application. I am getting it in this application.

Hope this help. If this doesn't help, kindly post your app.

Amay

sarfaraz_sheikh
Contributor III
Contributor III
Author

Dear All,

Please find my attached QVW for your reference....kindly check and help me.

Sarfaraz

arulsettu
Master III
Master III

i missed a )  have tried with this?