Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Need to join Other to collective Others (Rest of Data)

Hi there guys, hopefully someone can shed some light as I have been trying to find a workable solution for sme time and its really doing my head in.

I work for an Emergency Response company, for their claims model they have all the procceced claims against the respective medical aid companies.

We have a claims volume bar chart which lists the top 5 medical aid companies (with %), now in the backend system there are the companies as well as "Other". When generating the bar chart it displays the top 5 like so:

Med Co1

Med Co2

Med Co3

Other

Med Co4

Others

"Other" is an actual value in the database and "Others" is obviously the collective everything else.

What would be the best way to get everything except the top 5 into "Others", effectively combining Other and Others?

I have tried decreasing the sliver number but that only works on a global level, as soon as you drill down Other and Others creap back in.

Any help would be greatly appreciated.

3 Replies
Not applicable

Need to join Other to collective Others (Rest of Data)

Hi,

try to use this expression in the Sort tab of your graph (i guess it is currently sorted on Company dimension) :

=aggr(rank(sum (if ( Company <>'Other', Volume, 0)) ) , Company)

Hope this help.

Gilles

gandalfgray
Valued Contributor

Need to join Other to collective Others (Rest of Data)

Hi b

Do you mean that you want to disregard the "Other" medical aid company?

Or do you mean that you want to force "Other" into the Others group even if "Other" is one of the top 5?

/gg

Not applicable

Need to join Other to collective Others (Rest of Data)

Thanks Giles I will give it a try and see.

GG - Yeah I would like to force Other and Others as the collective rest together.

Community Browser