Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

antoniol
New 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
Honored Contributor

Re: rank for qlik sense bar chart

You want to calculate rank or need to prepare chart?

antoniol
New Contributor

Re: rank for qlik sense bar chart

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

Highlighted
shiveshsingh
Honored Contributor

Re: rank for qlik sense bar chart

Can i have sample data?

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