topic Re: Regarding Rank() in Expression for TOP 10 in QlikView

Regarding Rank() in Expression for TOP 10

sarfaraz_sheikh — Mon, 12 Jan 2015 13:19:08 GMT

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

Re: Regarding Rank() in Expression for TOP 10

arulsettu — Mon, 12 Jan 2015 13:25:35 GMT

hi try this

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

Re: Regarding Rank() in Expression for TOP 10

its_anandrjs — Mon, 12 Jan 2015 13:28:22 GMT

Hi,

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

Regards

Anand

Re: Regarding Rank() in Expression for TOP 10

sarfaraz_sheikh — Mon, 12 Jan 2015 14:01:52 GMT

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

Sarfaraz

Re: Regarding Rank() in Expression for TOP 10

sarfaraz_sheikh — Mon, 12 Jan 2015 14:13:36 GMT

Hi Arul,

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

Sarfaraz

Re: Regarding Rank() in Expression for TOP 10

Mon, 12 Jan 2015 14:43:20 GMT

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

Re: Regarding Rank() in Expression for TOP 10

sarfaraz_sheikh — Mon, 12 Jan 2015 14:50:30 GMT

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

Re: Regarding Rank() in Expression for TOP 10

Mon, 12 Jan 2015 15:02:09 GMT

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

Re: Regarding Rank() in Expression for TOP 10

sarfaraz_sheikh — Tue, 13 Jan 2015 06:35:07 GMT

Dear All,

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

Sarfaraz

Re: Regarding Rank() in Expression for TOP 10

arulsettu — Tue, 13 Jan 2015 06:40:35 GMT

i missed a ) have tried with this?

Re: Regarding Rank() in Expression for TOP 10

mdmukramali — Tue, 13 Jan 2015 07:01:44 GMT

Dear Sarfaraz,

in your attached Qvw file ,where it's showing '-' other than Dimensions?

Thanks,

Mukram

Re: Regarding Rank() in Expression for TOP 10

sarfaraz_sheikh — Tue, 13 Jan 2015 07:40:57 GMT

Dear Mukram,

Can u please post expression or QVW so it will be good to understand .........

Sarfaraz

Re: Regarding Rank() in Expression for TOP 10

sarfaraz_sheikh — Tue, 13 Jan 2015 08:02:23 GMT

Dear All,

Please look into matter.........its urgent .kindly help...

Sarfaraz

Re: Regarding Rank() in Expression for TOP 10

Tue, 13 Jan 2015 09:46:47 GMT

If you are talking about symbol before top 10 values in dimension, then go to presentation tab and check "always fully expanded" in your pivot table. Other than that I dont see any "-" symbol in dimension.

HTH

Amay

Re: Regarding Rank() in Expression for TOP 10

sarfaraz_sheikh — Tue, 13 Jan 2015 10:35:23 GMT

Dear Amay,

I am taking about symbol "-" which is showing in expression ......i dont want blank value in expression after calculating top 10 ...i just want top 10 to be appear in expression i dont want blank there ..

Sarfaraz

Re: Regarding Rank() in Expression for TOP 10

mdmukramali — Tue, 13 Jan 2015 10:53:30 GMT

Dear Sarfaraz,

Find the attached file.

and No Blank value in the Expression.

if your still able to see the blank value then please show as the blank value in the chart by taking the image.

Re: Regarding Rank() in Expression for TOP 10

sarfaraz_sheikh — Tue, 13 Jan 2015 12:19:20 GMT

Dear Mukram,

Please have the look on below screenshot..........

Sarfaraz

Re: Regarding Rank() in Expression for TOP 10

krishna20 — Tue, 13 Jan 2015 13:12:16 GMT

Hi Sheikh,

Try Like this

=aggr(if(Rank(total Sum([Revenue]))<=30, YourDimension), YourDimension)

Regards

Krishna