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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out 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?

Labels (1)
1 Solution

Accepted Solutions
MarcoWedel
MVP
MVP

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
MVP
MVP

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
MVP
MVP

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
MVP
MVP

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!