Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
alec1982
Specialist II
Specialist II

sort on bar chart based on expression issue

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?

1 Solution

Accepted Solutions
MarcoWedel

Hi,

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

QlikCommunity_Thread_170476_Pic1.JPG

QlikCommunity_Thread_170476_Pic2.JPG

hope this helps

regards

Marco

View solution in original post

6 Replies
sunny_talwar

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

Best,

Sunny

alec1982
Specialist II
Specialist II
Author

thank you. here is a sample image.

alec1982
Specialist II
Specialist II
Author

listed at the post body

sunny_talwar

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

MarcoWedel

Hi,

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

QlikCommunity_Thread_170476_Pic1.JPG

QlikCommunity_Thread_170476_Pic2.JPG

hope this helps

regards

Marco

alec1982
Specialist II
Specialist II
Author

good idea!