topic Re: Bottom problem in table in QlikView

Bottom problem in table

fkeuroglian — Fri, 10 Apr 2015 00:11:35 GMT

Hi expert

I have a problem, i create bottom table pivot but when i try to show, only put the TOP instead the bottom

i want the bottom 10 and show the top 10

what could be?

thank you a lot

attached the example

Re: Bottom problem in table

Anonymous — Fri, 10 Apr 2015 00:18:57 GMT

Sorry... I could not understand your problem. Please could you explain again?

Re: Bottom problem in table

jagan — Fri, 10 Apr 2015 03:27:02 GMT

Hi,

Try like this for Bottom 10, you have [Nombre Asesor] with zero values, to overcome this I have added this in expression [> 30]={'>0'}.

Dimension: [Nombre Asesor]

Expression:

If(aggr(if(

rank(-(SUM({<BanderaBanca={'0'}, [> 30]={'>0'} >} [> 30])

- SUM({<BanderaBanca={'0'},BanderaVenta={'0'},Año={$(vPriorYear)},Mes={$(vPriorMonth)}, [> 30]={'>0'}>} [> 30])))<=10,1),[Nombre Asesor]),

(SUM({<BanderaBanca={'0'}, [> 30]={'>0'}>} [> 30])

- SUM({<BanderaBanca={'0'},BanderaVenta={'0'},Año={$(vPriorYear)},Mes={$(vPriorMonth)}, [> 30]={'>0'}>} [> 30]) ))

Hope this helps you.

Regards,

Jagan.

Re: Bottom problem in table

fkeuroglian — Fri, 10 Apr 2015 11:58:42 GMT

Excellent Jagan, Thank you a lot

what is the difference that the value has zero ? what change?

Fernando

Re: Bottom problem in table

fkeuroglian — Fri, 10 Apr 2015 12:39:32 GMT

Jagan, how be with this expression?

If(aggr(if(

rank(-(SUM({<BanderaBanca={'0'}, [> 30]={'>0'} >} [> 30])

- SUM({<BanderaBanca={'0'},BanderaVenta={'0'},Año={$(vPriorYear)},Mes={$(vPriorMonth)}, [> 30]={'>0'}>} [> 30])))<=10,1),[Nombre Asesor]),

(SUM({<BanderaBanca={'0'}, [> 30]={'>0'}>} [> 30])

- SUM({<BanderaBanca={'0'},BanderaVenta={'0'},Año={$(vPriorYear)},Mes={$(vPriorMonth)}, [> 30]={'>0'}>} [> 30]) ))

thank you a lot Jagan, very useful and helpful

Re: Bottom problem in table

jagan — Mon, 13 Apr 2015 04:01:04 GMT

Hi Fernando,

You dimension has many 0 values, the bottom 10 are all zeros and zeroes are automatically supressing in the chart. If you want to view this you can uncheck Supress zero values option in Presentation tab.

Regards,

Jagan.