topic Re: Show Bottom 5 in Bar Chart?? in QlikView

Show Bottom 5 in Bar Chart??

Thu, 03 Dec 2015 11:06:01 GMT

Hi Friends,

I want to show bottom 5 values in Bar chart .This is sample data and logic.

F1	F2
100	f
90	a
85	o
80	e
75	j
70	g
65	c
60	b
55	i
50	h
45	l
40	d
35	m
30	k
15	n

I need to show bottom 5 values based on the condition that first I should arrange the data in descending order and after that I need to check 75% of the sum(F1). in this case it is 671. So I will consider only those (First) valuse whose sum is 671. Exclude all other values. So my result set will be

100	f
90	a
85	o
80	e
75	j
70	g
65	c
60	b
55	i

I need to show bottom 5 rom this result set in the Bar chart

75	j
70	g
65	c
60	b
55	i

Thanks in advance.

Re: Show Bottom 5 in Bar Chart??

Clever_Anjos — Thu, 03 Dec 2015 12:36:57 GMT

Use Dimension Limits Tab

Re: Show Bottom 5 in Bar Chart??

Thu, 03 Dec 2015 12:48:01 GMT

Hi divya,

first sort the loading order in reverse like

and next use the

Re: Show Bottom 5 in Bar Chart??

Thu, 03 Dec 2015 12:48:54 GMT

Hi,

When I show smallest 5 it shows

45	l
40	d
35	m
30	k
15	n

But I need to show

75	j
70	g
65	c
60	b
55	i

Re: Show Bottom 5 in Bar Chart??

tresB — Thu, 03 Dec 2015 13:07:55 GMT

Try expression something like:

Aggr(If(Rank(-Sum({<F2={"=Sum(F1)>Fractile(total F1,0.25)"}>}F1))<=5, Sum({<F2={"=Sum(F1)>Fractile(total F1,0.25)"}>}F1)), F2)