Bar Chart --> Top 5 and default dimension value in QlikSense

[abhijith28]

Hi All, @sunny_talwar 

Can anyone help me out with this scenario.

I have a Bar Chart and have to limit the values.

1. I have to show top 5 --> sum(values) among A,B,C,D,E,F exclude 'Default'

2. I have to show sum(values) for 'Default' value always in Bar Chart.

3. Others --> This includes the values which are apart from Top 5 and default.

Thanks & Regards,

Abhijith

[abhijith28]

i have "others" in my calculated dim, But it wont return the max values for "Others".

[Kushal_Chawda]

try below

=rangemax(max(aggr(If(aggr(Rank(sum(Balance)),State)<=5
or State='B', sum(Balance)),State)),
sum(aggr(If(aggr(Rank( sum(Balance)),State)<=5
or State='B',0,sum(Balance)),State)))

[sunny_talwar]

How about this

RangeMax(
Max(Aggr(If(Rank((Sum({<State-={'Defeased'}>} Balance) + 0 * Sum({<State-={'Defeased'}>} Balance))/(Sum({<State-={'Defeased'}>} CurrentBal) + 0 * Sum({1<State-={'Defeased'}>} CurrentBal))) <= 5,
(Sum(Balance) + 0 * Sum(Balance))/(Sum(CurrentBal) + 0 * Sum({1} CurrentBal))), State)),
(Sum({<State={'Defeased'}>}Balance) + 0 * Sum({<State={'Defeased'}>}Balance))/(Sum({<State={'Defeased'}>}CurrentBal) + 0 * Sum({1<State={'Defeased'}>} CurrentBal)),
(Sum({<State = {"=Rank((Sum({<State-={'Defeased'}>} Balance) + 0 * Sum({<State-={'Defeased'}>} Balance))/(Sum({<State-={'Defeased'}>} CurrentBal) + 0 * Sum({1<State-={'Defeased'}>} CurrentBal))) > 5"}>}Balance) +
0 * Sum({<State = {"=Rank((Sum({<State-={'Defeased'}>} Balance) + 0 * Sum({<State-={'Defeased'}>} Balance))/(Sum({<State-={'Defeased'}>} CurrentBal) + 0 * Sum({1<State-={'Defeased'}>} CurrentBal))) > 5"}>}Balance))/
(Sum({<State = {"=Rank((Sum({<State-={'Defeased'}>} Balance) + 0 * Sum({<State-={'Defeased'}>} Balance))/(Sum({<State-={'Defeased'}>} CurrentBal) + 0 * Sum({1<State-={'Defeased'}>} CurrentBal))) > 5"}>}CurrentBal) + 0 *
Sum({1} CurrentBal))
)

[abhijith28]

Hi @sunny_talwar  @Kushal_Chawda 

In Qliksense, I am finding the new issue with the selection of "others" in the Table.

1. After clicking on "Others", it returns the expected output.

2. After clicking on "others" for the second time (drilling down to second level) 

then it doesn't return the expected output.

Not able to drill down to further level in "Others".

Is it Qliksense bug?

Please provide the solution for this scenario.

Attached the sample app.

[sunny_talwar]

What do you expect to see when you click on "Others"

[abhijith28]

@sunny_talwar 

2nd time when i click on "Others".

It should show the below output.

The state which is under "Others".