topic Re: sort on bar chart based on expression issue in QlikView

sort on bar chart based on expression issue

alec1982 — Mon, 29 Jun 2015 19:15:33 GMT

Hi all,

I am in a need to sort a bar chart based on count. but i need to show only 9 bars. the highest in the middle and then 4 on each side descending both side to create a histogram..

Anyone knows how can I do it?

Re: sort on bar chart based on expression issue

sunny_talwar — Mon, 29 Jun 2015 19:18:00 GMT

We may be able to help, but we need to look at a sample. Can you provide one?

Best,

Sunny

Re: sort on bar chart based on expression issue

alec1982 — Mon, 29 Jun 2015 19:37:39 GMT

thank you. here is a sample image.

Re: sort on bar chart based on expression issue

alec1982 — Mon, 29 Jun 2015 19:38:15 GMT

listed at the post body

Re: sort on bar chart based on expression issue

sunny_talwar — Mon, 29 Jun 2015 19:47:09 GMT

By sample I meant a sample qvw document or sample excel file which can be loaded into the application to try it out. Desired or Expected output will be a plus

Sunny

Re: sort on bar chart based on expression issue

MarcoWedel — Mon, 29 Jun 2015 21:35:41 GMT

Hi,

the easiest solution might be to define dimension limits (provided the largest numbers are always coherent):

hope this helps

regards

Marco

Re: sort on bar chart based on expression issue

alec1982 — Tue, 30 Jun 2015 15:07:58 GMT

good idea!