Regarding Rank() in Expression for TOP 10

[sarfaraz_sheikh]

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

[arulsettu]

hi try this

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

[its_anandrjs]

Hi,

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

Regards

Anand

[sarfaraz_sheikh]

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

Sarfaraz

[sarfaraz_sheikh]

Hi Arul,

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

Sarfaraz

[#6]

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]

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

[#8]

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]

Dear All,

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

Sarfaraz

[arulsettu]

i missed a )  have tried with this?