topic Re: BOTTOM ANALYSIS in QlikView

BOTTOM ANALYSIS

Wed, 17 Jun 2015 07:52:21 GMT

Hello,

I am trying to get the bottom analysis using slider for my items and i'm not able to get it.Please help me out.

You can find the chart in the attachment.

Thanks

Atul

jsanchezh — Wed, 17 Jun 2015 08:25:09 GMT

Try to order them in "Ascending" mode for the Y-Value and select Higher than vBottom in the graphic properties

santhoo_san — Wed, 17 Jun 2015 08:29:58 GMT

is this you are looking for? see the attachment

Wed, 17 Jun 2015 08:33:46 GMT

No Sir, I want top 10 bottom items and the data should be played with the slider.But using the dimension limit,i'm not able to get it.

Wed, 17 Jun 2015 08:37:26 GMT

@jsanchezh‌Where do i get the graphic properties???

santhoo_san — Wed, 17 Jun 2015 08:39:09 GMT

Hi Atul,

it is working based on the slider selection only.

you just need to do

1. Sort your bar graph Y value Ascending

2. Remove Dimension Limit - Limit restriction

3. Enable chart scrolling - with your variable (vBottom)...

see the screen shot of of bottom 5 below

Wed, 17 Jun 2015 08:46:43 GMT

Dear Sir,

I just need Bottom 10 analysis with dimension limits.

antoniotiman — Wed, 17 Jun 2015 10:17:55 GMT

Hi Atul,

it depends on Null Values.

Try Calculated Dimension instead of @Chemical

=Aggr(If(Not IsNull(#AGEINGQTY), @Chemical),@Chemical)

Regards,

Antonio