Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
antoniol
Contributor
Contributor

rank for qlik sense bar chart

Hello, I have a problem I have to rank for a bar chart where the second bar is negative, so it must be facing down. It can be done?

 

3 Replies
shiveshsingh
Master
Master

You want to calculate rank or need to prepare chart?

antoniol
Contributor
Contributor
Author

Hi,

both, I used this expression Aggr (Rank (fabs (sum (dimension), dimension).

In the table it works, that is the number in negative places it in the second place but in bar graph no

shiveshsingh
Master
Master

Can i have sample data?

You are converting it into positive first and then using Aggr, how come you are getting negative values then?